Hi,

Is there anyone who can help with this little problem??

My overall aim is to take a spreadsheet, and with the data inside it copied and save into lots of different spreadsheets each with their own workbook. These individual workbooks, then need to be email to lots of different people.

Going deeper, the data in the first spreadsheet, where I am taking data from I need to check to ensure that I do not create duplicate spreadsheets. For example, if I have two rows called Frank, I want to create one workbook, not two. Further, as there could be rows with the same name, I want to copy all these rows into the one spreadsheet. Thus, if I have two rows called Frank, I want copy both of them into their workbook with the same name. Then I want create subtotals on the data in these individual works, and then email the workbooks to various people.

Does anyone have a code that can do this??? I really need it urgently!!!