Filter unique records using some value

Closed
Report
-
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
-
Hello,
I want VB script for filtering some unique records using some value from an excel sheet and coping them in another sheet using marco.

please help.

1 reply

Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
156
You can easily done by using

Data > Advanced Filter > here you can see option Copy to other location just check it and also check in Unique records only and in copy location give the different range in same sheet and after completing you can copy the data in other sheets .............

Sorry i don't ve enough macro knowledge ....