Re: Compare data in multiple columns across 2 worksheets
Okay, so attached is the scrubbed file. A note about what you're about to see... there are two worksheets with nearly identical information. Except the worksheet titled "TBP" has values in Column Z which are the most current. I'm trying to get those values into the right coordinates on "Sheet 1." The criteria I decided to use was the find a match for the name, the CPT, and the date, and if all that matches, then show the right value (TBP!Zn) somewhere in Sheet 1.
Also I believe JohnnyBeck solved it with his Macro. Upon further inspection, I found certain cells in Column Z of Sheet 1 to be have the correct value. THANK YOU but I am still interested in learning other ways of attacking this problem. And Johnny I'm hoping you take a look at this too, I must admit, though it appears your macro works a very small number of cells were changed (maybe 50 out of nearly 3,000) and I was expecting far more... in fact, its hard for me to tell whether I copied those over having the right value or whether the macro worked on them. Once all this checks out I can go ahead and roll it out for the rest of the files (another 127k lines, give or take 2... )
THANKS YOU GUYS!