Moving data in sheet depending on contents of a cell

Closed
Report
Posts
1
Registration date
Wednesday October 28, 2015
Status
Member
Last seen
October 28, 2015
-
 Blocked Profile -
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?

1 reply


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.