VBA Code to reject value in sheet1 if already in sheet2 and if not in sheet 2 move the said value to sheet 3

[WillemS]

Hi All,

I am trying to write a VBA code to perform the task mentioned in the title. Here are the specifics:

In my workbook a mail address came in in the Mail sheet, if the same mail address is already in sheet2 then the said mail address must be moved to sheet3, and if not in sheet 2 it must be moved to sheet1.
The process described above must run automatically as and when a new mail address arrives in the Mail sheet
Any help, please?

 

[offthelip]

I can see that you are a fairly new member to this forum and you are very welcome and I hope you find it helpful in solving your problems, I would draw your attention to Rule #4 of the forum rules.
thus I suggest you post your problem as a new thread

​

 

[WillemS]

Thank you, yes it is true. Much appreciated, I will load it as a new thread, though it was easier for you to answer back as you are already up to speed on what the first portion of the code does, instead of me re-explaining it all again.

Will post it ASAP.

 

[offthelip]

You can reference this thread with a link in your new post

 

[WillemS]

Ok great, thank you I will do so. Much appreciated.

 

[WillemS]

Hi it is posted under :

VBA Code to reject value in sheet1 if already in sheet2 and if not in sheet 2 move the said value to sheet 3 and send email to client​