ANAND KUMAR
New Member
- Joined
- Oct 20, 2016
- Messages
- 41
Dears,
I need some help to find matched numbers. I have a sheet and there are two columns; column A has few cities name upto 2828 (with duplicates) and the next one is in column C which contain unique values of cities available in column A (495 records - suffixed with some extra alphabet).
So now I want to highlight all the cities which are available in column A by mapping column C using VBA.
For better understanding uploaded attachment at below link,
https://drive.google.com/open?id=0Bxtc6jUuxe_paEVvV2s0QVllUkU
This time I used Text to column and then did Vlookup to match them; But it would be great if any VBA would help in this.
Thanks in advance. ☺
I need some help to find matched numbers. I have a sheet and there are two columns; column A has few cities name upto 2828 (with duplicates) and the next one is in column C which contain unique values of cities available in column A (495 records - suffixed with some extra alphabet).
So now I want to highlight all the cities which are available in column A by mapping column C using VBA.
For better understanding uploaded attachment at below link,
https://drive.google.com/open?id=0Bxtc6jUuxe_paEVvV2s0QVllUkU
This time I used Text to column and then did Vlookup to match them; But it would be great if any VBA would help in this.
Thanks in advance. ☺