moving data in sheet depending on contents of a cell Closed

Question

Hello, 

I have a sheet, where at the top, I have a table of all orders in production. In column "I" you can set the status of the order using data validation. 

When the Status is set to "Dispatched", I would like that the full line of that order will drop down into the dispatched table below. I don't need it to duplicate the row, I need it to move.

Secondly, when it drops, I need the latest dispatch to be at the top of that table

Can anyone help?

ac3mark · Answer

OK, post some code on what you are stuck with!  We can help on stuck, we cannot provide turn key solutions.  I always encourage newer users to record a macro, and reverse engineer the macro to custom fit your needs.  Like so:
    Rows("7:7").Select    Selection.Copy    Application.CutCopyMode = False    Selection.Cut    Sheets("DISPATCHED").Select    Rows("7:7").Select    ActiveSheet.Paste  

Let us know if you need help.

Moving data in sheet depending on contents of a cell

1 response

Similar discussions

Subscribe To Our Newsletter!