Hello,
Looking for code that will look in Col-A for the value = Apples, and if found,
will go to Col-B (on the same row where Apples was just found) and change
the cell to Oranges.
Col-A will contain the word Apples multiple times, and the word Apples will be
in a Cell all by itself. There are other fruits in Col-A, but only care about finding
any cell in Col-A that has the word Apples, and then going to Col-B and changing
the cell to Oranges !
Thanks,
Sherry
Bookmarks