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
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