VBA code to Remove duplicates and apply vlookup and sumif

Hello..
There are party names from column B11 (blank cell in Column B) and party codes are in other sheet "TIN Master" .. I want to copy Col B to O11 remove duplicates and apply vlookup in col. P11 with party codes... IFERROR(VLOOKUP(N11,'TIN Master'!$A$2:$B$4,2,FALSE),"NA")
And amount in col. G ... want to apply Sumif to Col. O4 SUMIF($B$11:$G$16,$N11,$G$11:$G$16)

Right now I am filling down the formula from P10 and Q10

Okay resolved by me.......

Please Login or Register  to view this content.