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

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!

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

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 he

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