richardcarter
Board Regular
- Joined
- Dec 10, 2003
- Messages
- 77
I have a list of names in Column A of a workbook (the length of the list will vary) and would like to create a macro which will automatically create a blank workbook for each name in the list.
For example,
A1: Jane
A2: Fred
A3: Harry
I would like to end up with 3 workbooks named Jane.xls, Fred.xls and Harry.xls in a folder in C:\My Documents.
Many thanks in advance to those who can help with what I think should be a simple macro.. but proving impossible to find anywhere!
For example,
A1: Jane
A2: Fred
A3: Harry
I would like to end up with 3 workbooks named Jane.xls, Fred.xls and Harry.xls in a folder in C:\My Documents.
Many thanks in advance to those who can help with what I think should be a simple macro.. but proving impossible to find anywhere!