Excel

B

Bhameo

How can I search a column for specific values and have all rows that contain
these values copied to another sheet?
 
G

Gord Dibben

Data>Filter>Autofilter.

F5>Special>Visible cells only.

Copy>paste to other sheet.


Gord Dibben MS Excel MVP
 
Top