Jun 04 2020 03:15 AM
Hello everyone,
My problem is :
I have a reference in Sheet 1, Cel A1: ='Sheet2'!E3
I want to drag the reference in Sheet 1, Cel A2 as : ='Sheet3'!E3 and in Sheet 1 cel A3:='Sheet4'!E3 etc etc etc.
I don't know how to drag the reference. It's concerning 100 sheets and different references at them which i want to show in sheet 1.
Please help me
Peter
Jun 04 2020 04:47 AM