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