Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving rows based on criteria
I would like to move entire rows based on a criteria in one of it's columns.
I would like to be able to bo this several times a day. I want it so it does not effect the order of the rest of the rows. example: if column 20 is shipped and is a date If column 20 have a value, then move it to worksheet "SHIPPED" I would like to have this so that I can run a macro, and have it move all shipped to the shipped folder. All BACKORDERED (column 21 and is a logical) if set to TRUE, move to worksheet BACKORDERED all (based on a value from a dropdown) that equal "AquaCulture" to worksheet "Aquaculturist" Thanks Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving rows with multiple criteria | Excel Worksheet Functions | |||
Moving cells based on certain criteria | Excel Discussion (Misc queries) | |||
Moving Rows to another sheet based on an entry | Excel Worksheet Functions | |||
Moving rows from one sheet to another based on a particular cell v | Excel Discussion (Misc queries) | |||
Sum based on criteria in rows and columns | Excel Discussion (Misc queries) |