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.