Hi All,
This is my first post, so please forgive my naive terminology....
I have a workbook with just one worksheet (master.xls with sheet1).
I would like to duplicate this file many times, each copy of the workbook should only include the single worksheet, the tab needs to be named from a list (the list is not part of the sheet I am duplicating) and the new workbook needs to be named the same as the tab, but with a month and year (the format of the date is not very important).
Eg the tab may be named “simon” and the sheet “simonAug2011”
The list is around 100 names, all short words with no spaces.
Many thanks in advance,
Simon