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!

Regards,
Sam

Sample SD.xlsx