Hi There,

In coloumn D i have a data validation list (N,Y,NA). If "N" is selected I want the entire row to move to the worksheet called "Declined Referrals".

How can i do this?

Many thanks
Jess