VBA code to copy multiple excel files to existing (already named) sheets of a master workbook

[Sunnykumar]

Scenario - There are multiple excel files in a folder whose data needs to be copied to specific (Already named) sheets of a master workbook

For example - there are 7 files in a folder and their must be pasted in 7 different existing sheets of the master workbook.

let's say, 1 of the source file named as "Data1.xlsx", Now this has to be pasted in a existing tab of the master workbook's sheet named "SalesData";
2nd source file named as Data2.xlsx, Now this has to be pasted in a existing tab of the master workbook's sheet named "Quota";
----------------- and so on ----------------- for all seven files-------------------------there are 7 designated named sheets in master file-------------------

I hope I was able to explain my situation.

Please help, I had been trying to search in many forums

Thanks in advance to all.

 

[alansidman]

crosspost: VBA code to copy multiple excel files to existing tabs in a master workbook - OzGrid Free Excel/VBA Help Forum

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.

 

[Sunnykumar]

I was unaware of the regulation.

However, I have mentioned the same in my question itself -

"Please help, I had been trying to search in many forums"

And, More to add I have not answered anywhere -

VBA code to copy multiple excel files to existing tabs in a master workbook - OzGrid Free Excel/VBA Help Forum

I Need help in coping files using VBA code. Scenario - There are few excel binary files, which needs to be copied to specific (Already named) tabs of a master workbook. For example - there are 7 files in a folder and they has to be pasted in 7 existing…

www.ozgrid.com