Hi

An easier way without coding is to go to the "Data" ribbon, select Advanced in the Filter section and a box will pop up. Choose filter copy to another location, click on list range and select the range you wish to filter, select "Unique Record Only", select the destination cell and click OK.

You will need to delete the original data as this is left intact.

Hope this is a bit easier for you.

Regards


Jeff