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.

1 reply

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
159
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