Faintkitara
Board Regular
- Joined
- Jun 23, 2016
- Messages
- 59
So I have a folder labeled "Weekly" with 6 different emails with "Scheduled Report" somewhere in the subject line. I need to create a macro that will copy each of those different sheets and paste them as different tabs in a specific excel workbook labeled "Revenue".
I then wanted to label each copied tab based on the Labels in the first cell. So if one copied sheet had "Monthly report w/0 Contingencies", I would want the Macro to catch "Contingencies" and automatically name the tab something that I wanted like "Plan"
But I would want it to do this exact thing for specifically the six other copied sheets and not the other tabs that may be listed in the document already.
Sorry its a lot, but is there a way to do this in VBA? What would the code look like?
I then wanted to label each copied tab based on the Labels in the first cell. So if one copied sheet had "Monthly report w/0 Contingencies", I would want the Macro to catch "Contingencies" and automatically name the tab something that I wanted like "Plan"
But I would want it to do this exact thing for specifically the six other copied sheets and not the other tabs that may be listed in the document already.
Sorry its a lot, but is there a way to do this in VBA? What would the code look like?
