Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to keep previous months' data
i have reports showing a 3 mo. trend. i've programmed the months to
automatically update, but i don't know how to program the data for that month to update as well....(i.e.) if jan=1, dec=2, and nov=3 in this month's report; next month my report will incorrectly read...feb=1, jan=2, dec=3. i need the current month's corresponding cells to clear, and the cells that correspond to prior months to automatically update. my report for next month should show...feb=no data, jan=1, dec=2. right now i am clearing and then reentering data. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Removing blank rows in a worksheet | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel |