Hey, Miss Kitty. I don't have a solution at hand; we'll have to work it out
together. But I'm a teacher by motivation; I wouldn't consent to just hand
you the solution even if I had it already written. What I'll do is explain
the bits of it to you, one at a time, until you understood them well enough
to write it yourself. "Teach a man to fish", and all that, you know. If
you're willing to take some time to learn it, I'll MAKE you that good with
macros :-) ...if you want to be.

If not, I think you're on the right track. The way to make it automatic,
eventually, is to write a Worksheet_Change subroutine, which fires
automatically whenever the user changes ANY cell (not just the one that marks
a customer as do-not-contact); you'd write to see whether this is that type
of change, and if it is move the row elsewhere. But if you're not that great
on macros I'd rather work with you on the details, if you're willing to take
the time.

--- "Miss Kitty" wrote:
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

--- "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.