| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I copy a set of cells based on a logical condition
I've names in column A and status level (low or medium or high) in column B.
I want to copy all 'names' with 'status level' as 'low' in to a different sheet through a formula. I do not want to do this manually. similarly all all 'names' with 'status level' as 'medium' in to a different sheet and so on. I also want the value to get updated automatically if I change the status in original sheet from 'low' to 'medium' |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Conditional Format based on 3 other cells. | Excel Discussion (Misc queries) | |||
| copy data from 1 worksheet to another based on a condition | Excel Worksheet Functions | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
Threaded Mode
