Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP PLEASE!! PROJECTING A WEEK ENDING PRODUCTION DATE | Excel Discussion (Misc queries) | |||
AVG row of data by Week ending | Excel Discussion (Misc queries) | |||
How to format cells to show dates as the week-ending date of that | Excel Worksheet Functions | |||
auto working week-ending date for timesheet | Excel Worksheet Functions | |||
Week ending | Excel Worksheet Functions |