Filter unique records using some value

Closed
SKD - Jun 29, 2009 at 04:59 AM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Jul 2, 2009 at 01:50 AM
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.
Related:

1 response

mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Jul 2, 2009 at 01:50 AM
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 ....


-1