Moving specific Row to another sheet.

[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?

 

[Bernie Deitrick]

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 Labut]

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 -

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.

 

[Gord Dibben]

Try Ron de Bruin's code from

http://www.rondebruin.nl/copy5_5.htm

The default code copies rows using unique values in Column A

After copying go back and delete the original data.


Gord Dibben MS Excel MVP