My Excel worksheet has 2 tabs called “MSTR_ACCOUNTS_3” (let us refer to it as Tab1) and “MSTR_custs” (let us refer to it as Tab2).
Col K of Tab1 is called “Other relationship” and contains numeric data.
Col A of Tab2 is called “RRN” and has numeric data.
I would like a macro which reads each “Other relationship” value in Tab1 and searches for a match in “RRN” of Tab2. Where a match is found it grabs the data relating to that RRN in rows D to V from Tab2 and copies it to the match in Tab1 starting in col AP.