I have a workbook with multiple worksheets. I want to be able to find the text in Worksheet B that matches the text string in a cell in Worksheet A. Once the exact text string is located in Worksheet B that matches Worksheet A, then I want that cell and the cell next to eat (e.g. A1 and A2) from Worksheet B copied over to Worksheet A next to the matching text. Note: There are more rows of data in Worksheet B than in Worsheet A. Also, if text is not found in Worksheet B, then leave the cells in Worksheet A, next to the orignial text string can be left blank. Also, if possible to have the merged data to go to another workheet (Worksheet C) that is combined would work also.
I've attached some dummy data in an excell spreadsheet that I can use if the VB Script, macro's etc are inserted / updated.
Thanks a lot, Chris