| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
not sure if am reading the question right, but it looks to me like you keep adding data accross the months in one row on one sheet, changing the "date" and data every time. You want to freeze the total on the 2nd sheet when you change the "date". I think the only way to do this is have a date associated with the input data - maybe row by row. Then you can easily add up the data associated with the input month -- duane ------------------------------------------------------------------------ duane's Profile: http://www.excelforum.com/member.php...o&userid=11624 View this thread: http://www.excelforum.com/showthread...hreadid=378384 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
| running totals in a macro for each month | Excel Worksheet Functions | |||
Hybrid Mode
