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?
Related:

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

Similar discussions

Excel - IF function with multiple words
Nick -
user -

14 responses
copy a row from one worksheet to another, based on criteria
wy -
vcoolio -

15 responses
Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses