Just to supplement, what you will do manually will select the top left cell
of your data in the header row and do

Data=Filter=Autofilter
select the dropdown in column A and select "yes"

It isn't clear that you know how to filter manually - but if you do, then
you can ignore this.

--
Regards,
Tom Ogilvy


"Harald Staff" wrote in message
...
Record a macro while doing it manually and you have it.

HTH. Best wishes Harald

"confused" skrev i melding
...
Hi,

Is it possible to use VBA to filter a worksheet? ie press a button which
will filter a worksheet so that only those rows with columnA = 'yes' are
displayed?

thanks for any help
cheers