Excel $ help!
I know im gonna sound thick amongst all you guys, but i dont get it!
Fee
"Barb Reinhardt" wrote:
I'm going to do this with a helper column so that you see what's happening.
A2 = 1
A3 = A2+1
A4 = A3 + 1
etc.
B2: =INDIRECT("Sheet"&A2&"!A6")
Copy down
"blinkgirl119" wrote:
Hi
I am looking to use the formula =Sheet1!A6 in a column, with the formula
changing each cell you go down, to =Sheet2!A6, =sheet3!A6 etc.... so it is
the sheet that changes, not the cell the data is getting taken from....how do
i do this? I think it is with the $ symbol, but i cant get it to work! Any
help will be appreciated!
Thanks in advance
Fiona
|