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

[JeAnFrLe]

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

JeAnFrLe wrote:
> 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
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html