| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I pull information from multiple existing spreadsheets int. | Excel Discussion (Misc queries) | |||
| How do I pull data from a previous worksheet? | Excel Worksheet Functions | |||
| how do i bring information from one worksheet to another in excel. | Excel Worksheet Functions | |||
| when copying a worksheet to a new one, some of the information do. | Excel Discussion (Misc queries) | |||
| Automatically pull data into another worksheet within the same fil | Excel Worksheet Functions | |||
Linear Mode
