Incrimentally update worksheet value

Talbot

New Member
Joined
Oct 13, 2006
Messages
3
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?
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,759
Members
410,704
Latest member
Cobber2008
Top