VBA How to get county out of the Address block and put it under County's column?

[vbanewbie68]

Hi Sir/Madam

Please find attached.

I want to tell macro to get off "West Sussex" under Donor Address line 1's column ,the last end, and then paste it into the Donor County's column? and Also how to remove commas as well Please? I have a list of hundreds like that.

Thank you in advance

Best Regards

V

 

[Peter_SSs]

For each row in my sample above, what would the message box say?
What would happen if we click Yes? (That is, what would go in column D and what would go in column F?)
What would happen if we click No? (That is, what would go in column D and what would go in column F?)

 

[vbanewbie68]

"Potential County Match please check" msgbox
If match then click yes then pull true value out of column D and put it Column F.
If no match then click No. No action is needed.

Hope it helps

Regards

V

 

[Peter_SSs]

pull true value out of column D and put it Column F.

How do we know what the "True" value is?

 

[vbanewbie68]

How do we know what the "True" value is?

From the table of counties (another workbook or worksheet) to find/search what Match county in the address block.

 

[Peter_SSs]

We seem to be going round in circles and I am just about done.

From the table of counties (another workbook or worksheet) to find/search what Match county in the address block.

Row 7 of my sample has no matches so I have no idea what to do if you answer 'Yes' or 'No' to the message box which says "Potential County Match please check" when there is no potential match.

Row 8 of my sample has 3 matches so I have no idea what to do if you answer 'Yes' or 'No' to the message box which says "Potential County Match please check".

 

[vbanewbie68]

Okay. I will have a go for myself creating a macro you provided, thanks for that and then to add new code in relation to counties check. I will update you if that is okay with you
Many thanks again for your time on this matter which is much appreciated. . I have learnt lots from you on vba.

Best regards