View Single Post
  #3   Report Post  
Joham Shason via OfficeKB.com
 
Posts: n/a
Default

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