Hi

Having applied the filter, there will only be a reduced number of
visible rows on the sheet.
Mark the whole block of visible rows, Copy then Paste to your new sheet.
Only the visible data will have been copied.

--
Regards

Roger Govier


"Hedgelayer2" wrote in message
...
Help! How can I filter rows of data via the contents of one of the
columns
and then copy the output of the filter (ie rows of data whos value in
the
filtering column are all the same) into another worksheet?

Thanks

Bob