Moving Rows Based on Field Entry

Hi Guys

Looking for some help

I have a basic spreadsheet i would like to paste information into on a regular basis but i would like a Column (J - Status) to default to PENDING when the information is imported
but once the task has been completed i would like to have a drop down list or pivot table so that i can select either PENDING, DEFERRED or COMPLETE

If the task is selected as COMPLETE - i would like the row to be cut and moved to a separate worksheet labelled 'Completed'

I assume i need to use a Macro but my knowledge of Excel is basic and i have tried using the forum but i know have a headache.

Any help would be greatly appreciated

Regards

Phil

Thanks Blokeman

Typical me trying to do it the hard way!

SOLVED