Indirect Method for Name Box Variable?

C

Chris Brennan

DARN
The reason I want to do this is that I have to collect data on a dail
basis but I have to display it on a graph on a weekly basis.

I select the entire week of cells and give it a name like week52.
The following week I have to select the entire week and name i
week53.
Everything is set up that I can just copy and the numbers will progres
for whatever length of time I need to graph (months, years, etc) excep
this.

Maybe I'll just go back to using the range of cell numbers.

Thanks guys
 
D

Dave Peterson

So did you try defining a Name as MyWeek and using your indirect formula in the
Refers to box?

MyWeek
=INDIRECT("week" & sheet1!$A$1)
 
Top