Copy Multiple Worksheets into a new Workbook

Daio

New Member
Joined
Sep 27, 2006
Messages
1
Hi there I would be greatful for somehelp in creating a macro to do the following:
I will have a workbook with many worksheets, the front worksheet will contain a table with no set number of rows and no set number of columns. In column A will be a list of e-mail addresses, in column B will be a new file name set and then in column C onwards it will refer to worksheet names in the current workbook, e.g. sheet2, sheet3 etc. When the macro is run it will need to look down column A to find entries where the @ sign is present, if the @ sign is present the sheets that are listed in the same row in columns C onwards will need to be copied to a new workbook and saved according to the name in column B. The new workbook/s will all need to be saved in the same folder.

Thanks
Dave
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Watch MrExcel Video

Forum statistics

Threads
1,113,916
Messages
5,545,020
Members
410,646
Latest member
LegenDSlayeR
Top