I have this macro problem that is driving me crazy.
How do I build a macro that first loops through one column (col A) and then one by one compares col A's values to different sheet's col C finding a match eventually. Then copies some data from the matching row. The loop goes on and second value in col A gets to matched with col C's values.
The number of rows in col A is unknown. Every value should have a match though in col C. When the match is found some data is copied from columns next to col C next col A in the same row.
I know that this would be really easy to solve with VLOOKUP or INDEX & MATCH but the point is to have a macro to do this because there is so much data.
I made a small excel example so it might be easier to understand what I'm after. I'm really stuck with making these two loops to work and would really appreciate help with them. Of the other stuff in the macro I might be able to manage (knocks on wood). Thanks a lot anyways, great forum!