Week Ending Reports

[Guest]

Hopefully someone can help me with this. I have a spread sheet that has
percentages in the first part and in the second part I have the numbers I use
to get my percentages. Different numbers for each week of the year is there
any way to automatically get the percentages to change in the first part when
I put in the numbers at the end of each week so that I don't have to change
the formulas to calculate different box numbers every time I run the report.

Any help is appreciated.

Thanks

 

[Cortez]

I currently do this by using the Indirect function, and inserting the
new weekly date before the old data cell, not after them.

So for example:

A1:A20 might be last week, I would insert a column at A1 and push last
week to B1:B20.

Somewhere else I will refer to info in A1 using "=indirect("A1")"
without the quotes. This will always show A1 even if the data is
"pushed" to another cell.

Let me know if this isn't clear.

TK