software

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

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 Govierquot;Hedgelayer2quot; gt; wrote in message
...
gt; Help! How can I filter rows of data via the contents of one of the
gt; columns
gt; and then copy the output of the filter (ie rows of data whos value in
gt; the
gt; filtering column are all the same) into another worksheet?
gt;
gt; Thanks
gt;
gt; Bob