Moving specific Row to another sheet.

  • Thread starter Thread starter Philip Labut
  • Start date Start date
P

Philip Labut

Is there a way that I can move an entire row to a second sheet by
searching for specific text in a specific column using an IF/Then
formula, or some other way?
 
Philip,

Do you want it moved, or extracted using formulas?

For formulas, simply use a VLOOKUP tied to some value:

=VLOOKUP(A2,Sheet2!$A$1:$Z$1000,Column(B1),False)

and then copy that formula across the row. Enter your key value in cell A2, and the other values
will be extracted automatically from the table on Sheet2.


HTH,
Bernie
MS Excel MVP
 
Philip,

Do you want it moved, or extracted using formulas?

For formulas, simply use a VLOOKUP tied to some value:

=VLOOKUP(A2,Sheet2!$A$1:$Z$1000,Column(B1),False)

and then copy that formula across the row.  Enter your key value in cell A2, and the other values
will be extracted automatically from the table on Sheet2.

HTH,
Bernie
MS Excel MVP






- Show quoted text -
Click to expand...

I think I want it moved, for example Sheet 1 looks like this

Hat 234 234 245 5 7
Bat 3 2 4 5 6
Bat 1 23 4 5 67
Bat 2 1 3 5 7
Bat 2 34 4 5 67
Bat 2 788 56 3 2
Bat 2 3 6 8 900
Cat 3 3 3 23 2
Cat 2 3 4 6 7


If Hat is in the first colums, I want that entire row and only that
rows values to move to Sheet 2. If Bat is in the firsrt column, I
want the entire row to move to sheet 3....so on and so forth.
 
Back
Top