ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Update a formula based on date worksheet was saved (https://www.excelbanter.com/excel-worksheet-functions/49006-update-formula-based-date-worksheet-saved.html)

Kevin McQuain

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


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com