copy multiple rows

G

Gord Dibben

Dianna

Try Data>Filter>Autofilter.

Filter on the common value in the column.

Copy and paste what is visble.

To print, filter then print. The hidden rows won't print.

Gord Dibben Excel MVP
 
Top