Workbook 1 name will always contain the words "Access Update" but the rest of the file name will change based on the date
Workbook 2 name will always contain the words "Outage Tracker" but the rest of the file name will change based on the month
1. Browse for Workbook 2
2. Add a new tab to Workbook 2 and rename it based on yesterday's date
3. Copy what's written on the "Outages" worksheet in Workbook 1 (which is where the macro launches from so it's already open)
4. Paste into A1 of the new tab created in step 2.
Any ideas on how to accomplish step 4? The code in Bold seems to be the trouble.
Or ideas how to simply my current code with perhaps SourceWB and DestinationWB?
Bookmarks