Thread: Automatic Move
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Aggie G Aggie G is offline
external usenet poster
 
Posts: 13
Default Automatic Move

I have a spreadsheet that has a column titled 'status'. Within this column I
have several status' like deferred, completed, in progress, etc. I want to
create code or something like it that will automatically move the row to
another sheet in the workbook when I change the status to complete. I do not
want the row to remain on the original sheet. I only want the information to
appear on the complete sheet.

How can I do this?

Aggie