Is it possible to use a macro like the one below, and have the second location save with the date / time stamp in the name ? This is what I need to accomplish: I have a few folks that need to make changes to a master spreadsheet daily. The spreadsheet is in a Network share that when modified and saved, will save to that network share, but also locally. Can the second location have the date/time stamp added to the name of the file so that I know when the changes were made and have an audit trail ? This will also keep a copy of the last modified file in case the spreadsheet is corrupted.
Here is what I have for saving to 2 locations:
Bookmarks