Select an entire row to copy after finding a value

  • Thread starter Thread starter steel_curtai
  • Start date Start date
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
 
If you mean in a macro
activecell.entirerow.select

If with an Excel shortcut
Shift+SpaceBar
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting a Copied Row inside a table 6
Excel Help to copy information from one row at a time to another sheet 1
Find 2 values & return row number 1
Return value in an table with variable columns and rows 2
moving rows to another sheet 3
Macro that copies values from column A (from formula) to B (paste value) 1
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
MACRO RUN random percentage and copy of column values 1

Back
Top