Hi all,
I have a request that I believe draws upon pretty standard elements but arranged in a very specific way.
Essentially the scenario consist of a user who needs to create a new Working copy of the most up to date Master workbook and then after doing that, reset the Master.
Necessary Steps:
- Copy the active worksheet ("Master")
- Paste the copy as a new worksheet ("Master [Today's Date]") with a dynamic date name based on today's date within the same workbook ("Filepath\Master.xlsm")
- Perform an index/match formula between columns in the new "Master Copy" worksheet and columns in a separate workbook hosted on Sharepoint ("Sharepoint Filepath\Working.xlsm").
- Index values of columns AN:BJ if the Match formula is successful.
- Paste the indexed columns as values in order to get rid of the formulas.
- Save the "Master Copy" worksheet as the new master "Working.xlsm" workbook ("Sharepoint Filepath\Working.xlsm")
- Delete the copied worksheet ("Master Copy") from the original workbook ("Filepath\Master.xlsm")
Does this make any sense?
In a nutshell:
- Copy a new worksheet
- Automatically perform Index/Math
- Paste values from Index/Match
- Save worksheet as new workbook
- Delete a worksheet from a workbook
Thanks everyone!!!
Bookmarks