grungernelly
New Member
- Joined
- May 6, 2011
- Messages
- 2
Hi I'm sure this can be done but I cannot for the life of me work it out.
In a nutshell I want to copy (create) multiple workbooks and name them based on the list
of filenames in Sheet1.
I have a sheet with a list of file names in column A e.g:-
A - 2011.xls
B - 2011.xls
C - 2011.xls
However, the basis of these newly 'spawned' workbooks will be all of the other
worksheets (let's say Sheet2 and Sheet3) in the master/creator workbook.
That is the first task. The second task is inserting the values of Column B (in Sheet 1
in the master sheet) into a specified cell in the newly spawned workbooks for example
these values
A
B
C
into Sheet2!A1.
The third and final task is to print Sheet2 of each new workbook to the default printer.
Can this be done? If only part of it can, this would be a great help.
Thanks in advance for your help.
Neil
In a nutshell I want to copy (create) multiple workbooks and name them based on the list
of filenames in Sheet1.
I have a sheet with a list of file names in column A e.g:-
A - 2011.xls
B - 2011.xls
C - 2011.xls
However, the basis of these newly 'spawned' workbooks will be all of the other
worksheets (let's say Sheet2 and Sheet3) in the master/creator workbook.
That is the first task. The second task is inserting the values of Column B (in Sheet 1
in the master sheet) into a specified cell in the newly spawned workbooks for example
these values
A
B
C
into Sheet2!A1.
The third and final task is to print Sheet2 of each new workbook to the default printer.
Can this be done? If only part of it can, this would be a great help.
Thanks in advance for your help.
Neil
