Select an entire row to copy after finding a value

S

steel_curtai

I am looking for a way to look for a value in a column and after
finding that column, selecting that whole row and copying it. Can
anyone help
 
D

David McRitchie

If you mean in a macro
activecell.entirerow.select

If with an Excel shortcut
Shift+SpaceBar
 
G

Gord Dibben

Select the column.

Edit>Find

Enter the value to find and "Find Next"

When found click on the row header and copy that row then paste to wherever.


Gord Dibben Excel MVP
 
Top