Indirect Method for Name Box Variable?

  • Thread starter Thread starter Chris Brennan
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect Method for Name Box Variable? 2
indirect 1
Indirect function countif 11
User-defined range for graph 3
#Ref! error using INDIRECT for file name 2
Excel Limit to Named Ranges 1
Copying data from a proteced worksheet 1
Change in graphs with Indirect? 1

Back
Top