Copying one sheet into another workbook (modifying existing macro)

Hi,

I have some code from the excellent Ron De Bruin website I need to modify. The below code filters column A, copies the filtered information and pastes it into a new workbook that is creates and saves. Rinse and repeat for each unique value in column A.

What I also need it to do each time it is run is to copy a worksheet (worksheetNew) from the workbook where this code resides and paste it into the new workbook that this macro creates each time it is run. Im sure it's fairly simple but despite triyng to work it out myself im coming a cropper.

Please Login or Register  to view this content.

Bump! Any help appreciated

Bump! Anyone?