How to export selected data to an excel from an excel

[vicky1586]

Dear Experts,

I have a requirement in which I need to generate a new excel file from an existing report.

In the newly generated file I need to copy some selected data from some tabs from the report. Please note that the report will be open at the time of the file generation.

Kindly help me with any suggestion of how this can be achieved using VBA.

Regards,
Vicky

 

[Joe4]

Welcome to the Board!

A great place to start is to use the Macro Recorder. Just turn on the Recorder and manually record yourself doing the steps manually. That will give you a lot of the VBA code you need, and then you can build off of that. Then post back here with specific details when you hit obstacles you cannot overcome.