How do I pull information from one worksheet to another using cer.

[Guest]

Example: In Worksheet Color: Column A has two choices, Red and Blue. I would
like to pull all of the rows that have Column A as Red to a new worksheet
called Red, and all of the rows that have Column A as Blue to a new worksheet
called blue. Any Suggestions would be great!

 

[Debra Dalgleish]

You can use an Advanced Filter to extract the data. There are
instructions here:

http://www.contextures.com/xladvfilter01.html#ExtractWs

Or, use and AutoFilter, and copy the data, then paste to the destination
sheet. There are AutoFilter instructions here:

http://www.contextures.com/xlautofilter01.html