Jun-12-2020, 03:45 AM
Hello,
I am so new at using python that I don’t know how to start the code.
I have 26 excel files (file1, file2, file3, etc) and I want to create a for loop that will open each file one at a time and copy sheet 1 and paste it into a new excel file called template.xlsx sheet 1, and then save the template as “new file 1”. Then open file2 copy data from sheet1 and paste it into template.xlsx sheet1 and do save as “new file 2”. And continue to do this process 24 more times.
Thank you,
Kristen
I am so new at using python that I don’t know how to start the code.
I have 26 excel files (file1, file2, file3, etc) and I want to create a for loop that will open each file one at a time and copy sheet 1 and paste it into a new excel file called template.xlsx sheet 1, and then save the template as “new file 1”. Then open file2 copy data from sheet1 and paste it into template.xlsx sheet1 and do save as “new file 2”. And continue to do this process 24 more times.
Thank you,
Kristen