Week Ending Reports
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 |
Week Ending Reports
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 On Mar 5, 2:48 pm, jmedwards2007 wrote: 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 |
All times are GMT +1. The time now is 05:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com