B Bhameo Jan 12, 2010 #1 How can I search a column for specific values and have all rows that contain these values copied to another sheet?
How can I search a column for specific values and have all rows that contain these values copied to another sheet?
G Gord Dibben Jan 13, 2010 #2 Data>Filter>Autofilter. F5>Special>Visible cells only. Copy>paste to other sheet. Gord Dibben MS Excel MVP
Data>Filter>Autofilter. F5>Special>Visible cells only. Copy>paste to other sheet. Gord Dibben MS Excel MVP
