View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patrice Patrice is offline
external usenet poster
 
Posts: 2
Default How to copy or move a row on a particular dropdown list selection

I have a file that track tasks. One of the colum (Status colum) contain a
dropdown list selection (ex: CLOSE, IN PROGRESS, RUSH, etc.)
1- On a certain selection, let's say "CLOSE", I want the content of that row
cut to an other sheet (CLOSE task sheet) of the same workbook.
2- On a certain selection, let's say "RUSH", I want the content of that row
copy to an other sheet (RUSH task sheet) of the same workbook.

So my trigger is the selection of my "status" in the drop down.
Can I do that ? If yes, anybody have a hint ?
Thanks!