I used PrepSheet_2 as test output so that the original data is not modified. you should do the same.
why it is not working as expected:
1) you changed the code of the macro (not only the name). you commented out
. But I added the comment that this can be only used if the whole cell content is the same as the find string. But
"AETNAEAP - Aetna - Employee Assistance Program" <> "Aetna - Employee Assistance Program"
==> you have to use the replace function!
2) in Table1 "Aetna - Medical Individual" is not found in "AETNAMI - Aetna - Medicare Individual"
Bookmarks