Previous Topic Next Topic

Moving data in sheet depending on contents of a cell

Closed
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
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

Answer 1 / 1
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: 

    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.
0