Copy an excel worksheet multiple times

Closed
TJ - Jun 13, 2011 at 07:13 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2011 at 05:29 PM
Hello,

I have an excel worksheet, which I want to make 38 copies of, and rename each copy with the initials of the person to whom it belongs. The initials are stored in another excel file. Can I do this via a batch file or something?
Please let me know.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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
0