How to copy all Excel sheets to another Excel

Closed
Jigisha - Feb 2, 2010 at 03:25 PM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 2, 2010 at 03:59 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 2, 2010 at 03:59 PM
Will you not lose your data if your transfer sheets from one workbook to other ?
0