Moving data in sheet depending on contents of a cell

joee74 Posts 1 Registration date Wednesday October 28, 2015 Status Member Last seen October 28, 2015 - Oct 28, 2015 at 10:18 AM
 Blocked Profile - Oct 28, 2015 at 04:53 PM

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 response

Blocked Profile
Oct 28, 2015 at 04:53 PM
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:

Application.CutCopyMode = False

Let us know if you need help.