How to copy all Excel sheets to another Excel [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have production data records for a year i.e 52 weeks

I have 52 Excel files containing 5 sheets in each Excel file (5 sheets have diff. formate)

Formate of all 5 pages same for all 52 Excel file's 5 pages

After correction in one folder how can i copy all sheets from one folder to other 51 Excel files at once

Please advice

Thanks

Jigisha

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Will you not lose your data if your transfer sheets from one workbook to other ?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!