VBA Create Sheets & Copy Applicable Data

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

Using a post which I found here http://www.mrexcel.com/forum/excel-q...worksheet.html

I've put together a very simple script shown (below) which creates sheets with the sheet name derived from cell values within a given range. The script then copies additional data from the 'Source' sheet and pastes this into the applicable 'Destination' sheet.

Please Login or Register  to view this content.

The problem I have is that this script runs against the whole workbook, so if there is more than one sheet which contains data when the macro is run, the script naturally has trouble in selecting the correct 'Source' information.

So I know that I need to specify the 'Source' sheet but I'm a little unsure about how to go about it. I just wondered whether someone may be able to look at this please and offer some guidance on how I may change this so that I can specify the 'Source' sheet as "Unique Records" and create the new worksheets in a new workbook whilst still keeping the rest of the current functionality.

Many thanks and kind regards

[hobbiton73]

Hi all, I just wanted to let you know that I've now managed to get this to work.

I can only assume that there must a typo because using the code above, except for creating the new workbook create the new sheets within, I can extract the correct source data.

Many thanks and kind regards