Move a row to another sheet in the same workbook based on the value of one cell

New to this forum. I realise there have been many of these threads posted previously, but I have been unable to adapt any of the solutions so that they work properly on my document.

What I need is for an entire row to be moved automatically from Sheet 1 (Live) to one of the other sheets based on what I put in Column K.

For example, if I enter 'Yes' into K2, I need the entire of row 2 to move to sheet 2 (awarded). If K3 is 'No' then row 3 needs to be moved to Sheet 3 (not awarded). If K4 is 'Withdrawn' then row 4 needs to be moved to Sheet 4 (withdrawn) etc etc.

It would be preferable if the data could be removed from Sheet 1 (Live) when it is placed in another sheet and placed on the next available row in its new sheet.

I hope this is clear enough.

I am using Excel 2010, and have attached a version of my workbook, if that helps.

Thanks

The code is on sheet live, not on standard module. When you change the rows in column K, that row will auto copy in to each respective sheet.

Thanks for the swift responses folks, much appreciated. Both solutions work, but since I would ideally like them to be moved automatically, without using a button, AB33 solution fits best.

I just have one question though. Is it possible to have the rows removed from the Live sheet when they are moved to one of the others? So if I was to put Yes for 'Robin' say, it would only appear in the Awarded sheet and no longer in the Live sheet?

Thanks a lot

You can add these lines to AB33's code:

Please Login or Register  to view this content.

Wonderful stuff! Big thanks to all for the swift and extremely helpful responses. Problem Solved.