Re: Macro To Import Data & Compare
Look at you Find functions inside the for loop. You are looking for temp taken from rng2 and searching for it in rng2. In other words, you'll always get a match. You have to change rng2.Find(...) to rng3.Find(...) and do the same for the next for loop