Hello All,
I have a workbook to track projects, which contains two sheets per project. One with the range I want to copy, which is on a sheet named after the project, and another with the timeline for the project, which includes "Timeline" in the sheet name. I've got a macro that filters a range, selects the information, and copies it, but only for one sheet (named after the project) and where I manually press a button to run the macro. There can be any number of projects in the workbook.
What I'm trying to figure out is if there is a way I could do the following:
1) For all sheets without the words "Timeline" or "Template" in them
2) Run the macro I've created to copy the appropriate information (fine using a button to call the code)
3) Paste the copied info into the body of an open email window from Outlook (the top of the body, progressively moving the data further down)
4) Add a title above the copied information with the sheet name so the pasted data can be identified as to which sheet it came from.
I envision that somehow this code would accomplish this one sheet at a time and just keep adding the pasted info to the top of the same open email (perhaps the code opens the new email at the beginning?) until it completes for all sheets meeting the criteria.
Any help would be appreciated!
Regards,
eforti
I have a workbook to track projects, which contains two sheets per project. One with the range I want to copy, which is on a sheet named after the project, and another with the timeline for the project, which includes "Timeline" in the sheet name. I've got a macro that filters a range, selects the information, and copies it, but only for one sheet (named after the project) and where I manually press a button to run the macro. There can be any number of projects in the workbook.
What I'm trying to figure out is if there is a way I could do the following:
1) For all sheets without the words "Timeline" or "Template" in them
2) Run the macro I've created to copy the appropriate information (fine using a button to call the code)
3) Paste the copied info into the body of an open email window from Outlook (the top of the body, progressively moving the data further down)
4) Add a title above the copied information with the sheet name so the pasted data can be identified as to which sheet it came from.
I envision that somehow this code would accomplish this one sheet at a time and just keep adding the pasted info to the top of the same open email (perhaps the code opens the new email at the beginning?) until it completes for all sheets meeting the criteria.
Any help would be appreciated!
Regards,
eforti