Macro that copy all data inside a workbook and paste in value in another document

Hi everyone,

I'm just a new member and this question must have already been solved several times, but anyway, I take my chance :

I run on a daily basis a very heavy excel file (15m) because he is full of dynamics links and macro.

I'm looking for a macro who copy every information in the document, open a new workbook and paste all data in value inside this new document.

Do you know how can I do that.

FYI, the name of the file is : PMO_multi_macro_hedged_usd

this file contains several tables : PTF, MAV, ref.


Thanks for your help

Hi
If I understand you correctly you may not need a macro to do this. Follow these steps:
On the sheet you wish to copy values from enter Ctrl+A.
Move to the new sheet in your new workbook and click on your starting cell.
Then right-click and choose Paste Special - then choose values only.
Hope this helps.
Good luck.
Tony

Hi,

Yeah, I could do that, but this is a very heavy file that I must send to a customer everyday.

So my ambition is :

1) TO create a macro realising what I described in my previous message
2) Via the same macro, send automatically am email with the new file inside