Move a row to another sheet with the same table when a column is filled out

Occasional Visitor

Good Day,

 

I am in need of help.  I am trying to set up a formula or something that allows me to move a whole row on a table to another sheet that has the same table when a date is inserted into a column.  For instance i have product that is ordered goes on my first sheet.  When the product is ordered and it becomes shipped i want to be able to fill in the ship date and that whole row moves over to my ship tab.  Any help? I have attached the excel sheet as to what i am talking about

2 Replies

@zacluc91 Can't help wondering why you would want to move rows to another sheet, just because the status of the row changes. In stead, consider to use various filter options to create overviews depending on status. Just a thought.

I would like to do the same thing too. I need them moved for a pipeline I am creating. I do not think filtering will help since they will need to be moved into the appropriate project sheet once ordered.