How to copy all Excel sheets to another Excel

Closed
Jigisha - Feb 2, 2010 at 03:25 PM
rizvisa1 Posts 4478 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
Related:

1 response

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