I want to look at the entire cell exactly for each row on SheetDB column A. If the word in each cell there is found exactly in any row in Column A on SheetX then I want the macro to replace the cell on SheetX to what is in SheetDB column B on the row where the word is matched.
Duplicate thread: http://www.excelforum.com/excel-prog...hin-range.html
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks