View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Phillips Phillips is offline
external usenet poster
 
Posts: 48
Default 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