Hello, this is my very first post here and I'm new to VBA.
I have tried different approach to my problem but haven't got solved.
I have values in column H and I on Sheet1 and a list of 13963 records on A and B from Sheet2.
I need to compare H1 sheet1 = any A in sheet1 AND I1 sheet1 = adjacent B from sheet2. If both values matches then need to copy value of C sheet 2 to J1.
This must be done for any not null cells in column H.
Thanks for any tips, anything is welcomed!
Bookmarks