Hello,
I have two columns of data and my goal is... The macro looks through column B and replaces the value in column A.
Presently I have a dictionary that loads a bunch of values into an array.
Search Criteria |
New Value |
Bob |
BDone |
Chuck |
CDone |
Now if the data looks like this:
|
A |
B |
1 |
Data |
Data |
2 |
Data |
Data |
3 |
Data |
Chuck |
4 |
Data |
Data |
The result I'm trying to get would look like this:
|
A |
B |
1 |
Data |
Data |
2 |
Data |
Data |
3 |
CDone |
Chuck |
4 |
Data |
Data |
Unfortunatenly I can only get it to replace the found value. Offsetting the range naturally just changes where it looks to replace the value.
|
A |
B |
1 |
Data |
Data |
2 |
Data |
Data |
3 |
Data |
CDone |
4 |
Data |
Data |
The code I'm using which at this point only replaces the range it is looking through.
The reason for using a dictionary is the speed. I had a find and replace in another portion of this project and it would take an additional 10-30 minutes depending on the number of lines. Using the dictionary reduced the time drastically.
Bookmarks