Although the right thought, that will evoke an error message (you can only
copy data to the active sheet). To get this to work going to another sheet,
you have to start from the destination. You should select a cell on the
destination sheet, then do Data=Filter=Advance Filter. You may get a
message that it can't find your data, but just click OK and continue. You
can then select in the resulting dialog and specify copy to another
location, then click in the List Range box and navigate to and highlight
your data range, (leave criteria blank), and click the unique values
checkbox, then click OK.

--
Regards,
Tom Ogilvy



"Frank Kabel" wrote in message
...
Hi
without macros
- select your range
- goto 'Data - Filter - Advanced Filter'
- check 'Unique values' and choose your other sheet as target location
- finish the wizard

--
Regards
Frank Kabel
Frankfurt, Germany

Hi,

Would anyone be able to help me with the following please.

I want to select a range of rows use a macro to identify which of
those entries are duplicates - ie the entire row matches another row
in the selection?

In an ideal situation the duplicates will be moved to a new sheet -
called duplicates - with the unique rows being moved to a new sheet
called uniques.

The original data will remain in the original sheet.

Many many thanks for any help you can offer


---
Message posted from http://www.ExcelForum.com/