Hello,
I have a problem creating a sequence of an =INDIRECT formula.
Sheet2:
Formula in C2:
=INDIRECT("'"&$C$1&"'!A1") in "Sheet 2"
C1: name of sheet1
Sheet1:
Data in A1, A2 etc.
Problem:
I want to create a sequence of the formula in C2, A1 must change to A2, A3 etc
Like this...