You can do this with an Advanced Filter, but you must start from the
sheet on which you want the results (the destination sheet). There are
instructions he

http://www.contextures.com/xladvfilter01.html

ric wrote:
Hi,

I'm looking to filter a column which has multiples of the same string and
creating a definitive list on another worksheet. i.e.

Column A "data" sheet
bed
cog
dog
bed
dog
cog

So what I am looking to do is filter column A from row 2 to get a result of

Column A "summary" sheet
bed
cog
dog

The list isn't a set length long on "data" sheet so it needs to keep going
till it reaches a blank cell.

Regards

Ric




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html