Incrimentally update worksheet value

[Talbot]

I have a main worksheet that holds the YTD data, I want it to pull it's numbers from my weekly data. The formula I'm using is ='Week 1'!$Q$5, but when I want to copy that to other cells in my YTD, I can't seem to get it to change the worksheet reference. I would like it to change "Week 1" to "Week 2", then on the next line "Week 3", etc.

Is there a way to do this?

 

[pgc01]

Hi Talbot
Welcome to the board

You can use INDIRECT.

For example write in A2:

=INDIRECT("'Week "&ROWS($A$2:A2)&"'!$Q$5")
Copy down

Hope this helps
PGC

 

[Talbot]

WOW

That was great, works like a charm

Thank you so much. :D