Excel

H

Hedgelayer2

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
 
R

Roger Govier

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.
 
Top