How to copy all Excel sheets to another Excel

Closed
Jigisha - 2 Feb 2010 à 15:25
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 2 Feb 2010 à 15:59
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
2 Feb 2010 à 15:59
Will you not lose your data if your transfer sheets from one workbook to other ?