Copy and paste specific data to new worksheets instead of new workbooks

Hi All,

I have a code which takes the unique values in column F and pastes all the data in it into a new workbook. I have tried to use the same code (below) but change it so that instead of copying in the data into a new workbook, it does it into a new worksheet in the same workbook. I'm just not sure of the language to use - I tried just changing "book" to "sheet" but that obviously didn't work (see below), and my macro skills are beginner level.

Can anyone help please?

Please Login or Register  to view this content.

Maybe:

Please Login or Register  to view this content.

Hi John,

Thanks for your help.

For some reason it's looking for a For statement where "Next Cell" is?

Cheers

Where is the opening loop in your code? You have next cell closed, but where is

Please Login or Register  to view this content.

statement ?
The code as it is now should error.

Assuming this pic comes through ok - this is what I am getting.

10-01-2014 11-00-49 AM.png

Yes, the code errors on next cell line.
This code works, but if you re-run it, you will get another error saying the sheet name exists.
Try it and will adjust the code.

Please Login or Register  to view this content.