Hi,
You can do it by using the filter options in data menu. Just check this
steps out.
Go to data -- FILTER -- advanced filter -- Select copy to another
location -- select the list range - select the new location where data
should be copied -- Check Unique records and click on OK.
That should work.
C Ya.
--
Message posted via
http://www.officekb.com