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.
Should add an example:
So SheetDB cell A5 might contain 'John'. The macro would search for 'John' within column A on SheetX and if an exact match is found replace the cell on SheetX with what is in SheetDB cell B5.
Hi ScrappyDog
This seems fairly simple, with probably many ways to accomplish
For example, you can use the Range.Find method applied to Column A in SheetDB to find the cell , as a Range Object , with the string that you are searching for. Applying the .Row Property to that found Cell Range Object will give you the row of the Cell in Column B you wish to then copy to the SheetX
So what have you tried, and where is the problem?
Alan
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks