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 Labut" wrote in message
...
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?

On Oct 1, 10:28*am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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" wrote in message

...



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?- Hide quoted text -

- 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.

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

On Wed, 14 Oct 2009 10:21:36 -0700 (PDT), Philip Labut
wrote:

On Oct 1, 10:28*am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
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" wrote in message

...



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?- Hide quoted text -

- 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.