Hey Bob,
Thanks for your prompt reply.
I am not that great with Macros. Would you happen to have a solution for me?
I also have to cut specific information from the list in Sheet1 that I would
need to paste into Sheet2.
What I have at the moment is:

With Sheets("Sheet1")
.Range("A2:L15").Cut Destination:=Sheets("Sheet2").Range("A1")
.Range("CA2:IV11").Cout Destination:=Sheets("Sheet1").Range("CA7")
End With

Any help would be appreciated.
--
Miss Kitty


"Bob Bridges" wrote:

I think you can easily enough mark a row "no longer to be contacted", and
have your lookup functions etc properly ignore those rows until you can get
around to moving them somewhere. I can also think of a way with formulae to
create a list of all the customer rows so marked, though it's a bit kludgy.
But I don't see a way to do the actual relocation of that data with worksheet
formulae; I'd use a macro for that.

--- "Miss Kitty" wrote:
...when a customer no longer wants to be contacted I would like the rows
associated with it to cut and paste into a sepearte worksheet automatically....As
soon as DNC is selected from the validation list it needs to becut and pasted into
the other worksheet automatically.