Macro to create new excel file from specific sheets and send by mail

samdk

New member
Joined
Dec 14, 2018
Messages
13
Reaction score
0
Points
1
Location
Paris
Excel Version(s)
O365
Hello everyone,

For a few days I'm trying to figure out some VBA coding and as I'm no expert, can't figure out where I messed up my coding.

You'll find attached to this post an example of the file on which I need to apply the macro and to link it to the button on the "To do" sheet.

I need to create a new excel file and copy as values (not as a pivot table) the sheets named "TCD 1" and "TCD 2" (which will be filtered from the "To do" sheet), but at the same time to keep the format of the sheet.

Then to save the created file named as "Next ABC" in the same folder and send it as an attachment in outlook.

If more information is needed, just let me know.

Thanks in advance for your help and time! :smile:

Regards,
Sam

View attachment Sample SD.xlsx
 
Back
Top