Hi, I have a formula in Sheet2 A1 ='Sheet1!A1
On Sheet2 A2 I have =A1 in the cell
When I drag this down in Sheet2 I need every other cell to increase by one so that I get this output
A1 = SDI[1] "COMES FROM SHEET 1 CELL A1"
A2 = SDI[1] = A1
A3 = SDI[2] "COMES FROM SHEET 1 CELL A2"
A4 = SDI[2] = A3
AND SO ON
This is the output I am currently getting
A1 = SDI[1] "COMES FROM SHEET 1 CELL A1"
A2 = SDI[1] = A1
A3 = SDI[3] "COMES FROM SHEET 1 CELL A3"
A4 = SDI[3] = A3
Is this possible, i am racking my brain.
Bookmarks