Copy an excel worksheet multiple times

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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