I have a workbook which has financial forecasts. Since the forecasts are always changing I need a macro that when executed will
1) Copy the value from the following cell "='Project Finance View Summary'!J25"
the cells range from ='Project Finance View Summary'!D19:AD33
2) Paste in sheet "Base Line Historical" with date time and author
I would like to have this looped so i can keep a historical log of each time the base has been saved. An option to overwrite the last save would be a nice to have feature.
Bookmarks