Hi There!

I am totally new to this sort of thing in Excel, however I have found myself in need of a way to move a row from one sheet to another when a value is entered from a drop down box.

Basically, in column M of sheet 1 (titled Master Sheet), if 'Ready To Process' is selected from the drop down box I need the whole row to be moved over to sheet 2 (titled Ready To Process) and deleted from the original sheet. I need each row added to the second sheet to appear on the next available row.

I've seen other examples of this type of requirement before, but being a novice I haven't been able to amend it to suit my own needs.

If you need anything else to help work this out let me know!

Thanks in advance to anyone able to help me with this. :-)

Andrew