Hello! I'm trying to compare a data set against the master list to find a match. Once a match is found I want to copy the data in the adjacent columns back to my original list. Here is my code so far.
The data being compared begins in "A1" (on my data set) and "E2" (in my master list). If A1 doesn't match E2 I want to check it against E3 and so on until a match is found. Once the match is made I want to select columns A - D of my master list and paste it next to the corresponding match in my data set. Hopefully this all makes sense. ThanksPlease Login or Register to view this content.
Bookmarks