Hi all,
I have a simple Sub that replaces one value in a cell with another from a lookup table. It loops around the length of the column replacing row by row
Sub UpdateCountry()
Dim lr As Long, i As Long
Dim CountryCol As Range
Dim x As Variant
Set ws1 = Sheets("2. Final Data")...