Killswitch
New Member
- Joined
- Jul 30, 2011
- Messages
- 2
Hi all, long time reader, first time poster. I've got problem that has me stumped, and would be hugely appreciative of any advice. I use Excel 2003 and Windows XP. The problem is as follows...
I receive data, containing addresses (Up to 100,000 in some cases). Each country needs to be assigned a code, this is done for sorting purposes (USA - NA1, for example). So I want a macro that will loop through the selection (country column) and write the relevant code in the next cell in the row (sort code column)
I could do this via v-look up, without need for VBA, but the data comes in from different sources, so the data is inconsistent, either alternative country names or old-fashioned spelling mistakes.
Getting around the inconsistencies is the next step, but first I need to get the first step working. Is what I'm trying to do possible?
I'd be massively thankful for any advice.
I receive data, containing addresses (Up to 100,000 in some cases). Each country needs to be assigned a code, this is done for sorting purposes (USA - NA1, for example). So I want a macro that will loop through the selection (country column) and write the relevant code in the next cell in the row (sort code column)
I could do this via v-look up, without need for VBA, but the data comes in from different sources, so the data is inconsistent, either alternative country names or old-fashioned spelling mistakes.
Getting around the inconsistencies is the next step, but first I need to get the first step working. Is what I'm trying to do possible?
I'd be massively thankful for any advice.
