Menu
  1. Accueil
  2. Tech Forum
  3. Office Software

Filter unique records using some value [Closed]

Report
-
Posts
191
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.
See more

1 reply

Answer 1 / 1
Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
 212
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 ....


Ask a question