alexbrown61
New Member
- Joined
- Jul 10, 2010
- Messages
- 13
I have a spreadsheet that comes to me monthly. One particular column "organization" always has the exact same mispellings in it. I need to correct the spellings before further proccessing. Here is an example of the column that I need to change:
Organization (This is the column name)
Federal Center
Federal Ctr
Operations Center
Operations Ctr
Request VBA code that will change the data in the column using a lookup table named "Org" to replace with the correct and consistent names of the organizations.
I have huge amounts of data and would like to use VBA. I'm using W7 and E2007.
Thanks in advance for you help.
Alex
Organization (This is the column name)
Federal Center
Federal Ctr
Operations Center
Operations Ctr
Request VBA code that will change the data in the column using a lookup table named "Org" to replace with the correct and consistent names of the organizations.
I have huge amounts of data and would like to use VBA. I'm using W7 and E2007.
Thanks in advance for you help.
Alex