Goto:

Data: - Filter - Advance Filter

here select filter for unique values in place..

then:

ctlr + g this will open a goto dialogue box.. here select special and
then in options select visible cells ... copy the cells and paste it in
another worksheet.. this a simple and second fast method.
you can even record macro for this.


---
Message posted from http://www.ExcelForum.com/