I have a list of data that extends for several thousand rows and over to
column T. Column E has a list of data that is only one of 4 things. I need to
transfer entire rows based on the option listed in Column E. If the 4 options
are follows: car, truck, van, and other. I need all the rows that say car to
be pulled from the sheet that has everything on it to the sheet named car and
the same thing for all the others. I was thinking of making a vlookup formula
for every column from A-T and then copy down but that would just result in
the same info over in over if I am not mistaken. Any help is appreciated.

please send you workbook to me

my

"Chad" wrote:

I have a list of data that extends for several thousand rows and over to
column T. Column E has a list of data that is only one of 4 things. I need to
transfer entire rows based on the option listed in Column E. If the 4 options
are follows: car, truck, van, and other. I need all the rows that say car to
be pulled from the sheet that has everything on it to the sheet named car and
the same thing for all the others. I was thinking of making a vlookup formula
for every column from A-T and then copy down but that would just result in
the same info over in over if I am not mistaken. Any help is appreciated.

Filter the list; copy and paste.
--
Jim Cone
Portland, Oregon USA



"Chad"
<Chad
wrote in message
I have a list of data that extends for several thousand rows and over to
column T. Column E has a list of data that is only one of 4 things. I need to
transfer entire rows based on the option listed in Column E. If the 4 options
are follows: car, truck, van, and other. I need all the rows that say car to
be pulled from the sheet that has everything on it to the sheet named car and
the same thing for all the others. I was thinking of making a vlookup formula
for every column from A-T and then copy down but that would just result in
the same info over in over if I am not mistaken. Any help is appreciated.

I can not send the workbook to anyone for company reasons and the idea of
filter and copy paste does not work well cause something I forgot to mention
is the orginal list gets updated every 30 mins.

Debra Dalgleish has some code to copy filtered rows here...
http://www.contextures.on.ca/xlautofilter03.html
(Note: it won't work on xl97)
--
Jim Cone
Portland, Oregon USA



"Chad Portman"

wrote in message
I can not send the workbook to anyone for company reasons and the idea of
filter and copy paste does not work well cause something I forgot to mention
is the orginal list gets updated every 30 mins.

same kind of question asked last two days back by someone in the
group.

Assumed Col E - has no blank cells e.g.,
Col E
Car
Truck

Van
Other

if cell E1 has car , then whole row need to copied and paste to sheet
which is named as car ?

Is this you are looking for ? then use the below macro to copy.
Note : before running the macro insert sheets according to the names
mentioned in Col E ( as car, truck,van,other)

Assumed whole data is in sheet1

Sub trs_data()
Range("E1").Select
rng1 = Cells(Rows.Count, "e").End(xlUp).Row
For a = 1 To rng1
If ActiveCell.Value < "" Then
temp = ActiveCell.Value
Else
ActiveCell.Offset(1, 0).Select
End If
If Cells(a, 5) = temp Then
Rows(a).Copy
Sheets(temp).Select
rng = Cells(Rows.Count, "d").End(xlUp).Row
Cells(rng + 1, 1).Select
ActiveSheet.Paste
Sheets("sheet1").Select
Else
End If
Cells(a + 1, 5).Select
Next
Application.CutCopyMode = False
End Sub




On Feb 25, 8:08*am, Chad <Chad
wrote:
I have a list of data that extends for several thousand rows and over to
column T. Column E has a list of data that is only one of 4 things. I need to
transfer entire rows based on the option listed in Column E. If the 4 options
are follows: car, truck, van, and other. I need all the rows that say car to
be pulled from the sheet that has everything on it to the sheet named car and
the same thing for all the others. I was thinking of making a vlookup formula
for every column from A-T and then copy down but that would just result in
the same info over in over if I am not mistaken. Any help is appreciated.