Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update a formula based on date worksheet was saved
I'm trying to update a weekly report that contains historic data.
the challenge is to count only the new information based on the date the worksheet or workbook was saved as. For example if the worksheet was saved as worksheet 9.30, I want to count and update only the data entered after the saved date of 9.30. Because the report is weekly, I need to update on a dynamic basis. Any help will be greatly appreciated. -- KevinM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Update Worksheet to Worksheet | Excel Worksheet Functions | |||
Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |