Hi - I need help with my excel sheet; below are the details:
Two tabs ("Sheet1", "Sheet2")
I need to run code to search Column A in "Sheet1" and eventually replace columns B, D and E of the same spreadsheet with information from "Sheet2" depending on the search results.
The code would tell the spreadsheet:
If the first 4 characters of any cell within column A on "Sheet1" match the first 4 characters in any cell in Columns A, B, or C in "Sheet2", Then Columns B, D and E on "Sheet1" would be replaced by Columns D, E and F on "Sheet2" in that specific row.
I hope this makes sense. Thanks for any help in advance!
Bookmarks