Hello,
I have almost "0" experience in VBA. I would be thankful for anyone who can help me create a macro for:
There are two sheets in a workbook, both sheets have same two columns (A & B) which are part number (PN) and serial number (SN), but order of PN & SN are different on two sheets.
Macro is required to compare columns A & B on two sheets, if there equal (A&B from sheet1 = A&B from sheet2) then copy data from column C - "prices" from sheet1 to sheet2.
Data needs to be copied in order of A&B columns from sheet2.
Bookmarks