The information gathered is for Communitic International to ensure the sending of the newsletter.
The information will be used subject to terms and conditions, for advertising purposes.
You reserve the right to access and change your personal data, aswell as the right to request its deletion within the limits permitted by law.
You can also review your targeting options. For more information, click this privacy policy
.
thanks again
To implement this code:
Open VB editor (ALT+F11).
Goto top menu, insert, module.
Paste the code in the big white field.
To run the code:
Hit ALT+F8 to open a window which displays the available macro's.
I don't understand the issue which you describe in your last post.
If data looks like:
Reference Raw
ab ab
cd ab
ab xs
gf ab
Then result will be:
Reference Raw
ab ab Match
cd ab Match
ab xs
gf ab Match
In this example there are 3 matches which are all found.
Can you give an example which the code doesn't handle correctly?
Best regards,
Trowa
reference data(sheet1)----------------raw data(sheet2)---------------sheet 3
English--------------------------------thank you Trowa------------------
Russia--------------------------------he cannot speak English------match or say (English)
thanks again
Try the following code:
Best regards,
Trowa
thank u so much for giving your time to my question..
i really appreciate you!!