Hi,
I maintain a workbook with 11 worksheets in it (named Sheet1, sheet2, etc).Each sheet contains information that i have to email to individuals. Ex: sheet 1 to user A, sheet 2 to user B, etc.
Currently, i copy the sheet and paste it to a new workbook, save it, and then email to all the 11 users.
Can you help me with the macro, which automates this process. It should basically copy the sheet, create a new book, and the file name should be the same as the sheet name.
Thanks in advance.
I maintain a workbook with 11 worksheets in it (named Sheet1, sheet2, etc).Each sheet contains information that i have to email to individuals. Ex: sheet 1 to user A, sheet 2 to user B, etc.
Currently, i copy the sheet and paste it to a new workbook, save it, and then email to all the 11 users.
Can you help me with the macro, which automates this process. It should basically copy the sheet, create a new book, and the file name should be the same as the sheet name.
Thanks in advance.