Copy an excel worksheet multiple times
Closed
TJ
-
Jun 13, 2011 at 07:13 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2011 at 05:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2011 at 05:29 PM
Related:
- Copy an excel worksheet multiple times
- Transfer data from one excel worksheet to another automatically - Guide
- Allow multiple downloads chrome - Guide
- Excel date format dd.mm.yyyy - Guide
- How to delete multiple files at once - Guide
- Excel free download - Download - Spreadsheets
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 14, 2011 at 05:29 PM
Jun 14, 2011 at 05:29 PM
you can do with a macro. you can have macro either in the file in which you want to create the sheets or the file in which you have the data.
basic idea would be
1. open the file with macro (lets say it is the file in the book in which you want to copy the sheets)
2. via macro open the file that has data
3. start reading line by line the data. and for each line, create the sheet. rename it to value
basic idea would be
1. open the file with macro (lets say it is the file in the book in which you want to copy the sheets)
2. via macro open the file that has data
3. start reading line by line the data. and for each line, create the sheet. rename it to value
