Extract necessary information from excel sheet

[mkim41]

hey

I need your help guys...

I attached the excel sheet (Vendor List(1).xls)....(In this excel sheet, there areonly 3 different vendors, but original data files contains more than 50 vendors...)

This excel sheet contains buch of data about vendors.......

I want to extract the information that I need (Vendor #, Vendor Address, Bank name, Bank Account, Swiftcode, Account Hold)...

I also attached another excel sheet (Desired Vendor List.xls)...

I want to make exactly like Desired Vendor List.xls.from Vendor List(1).xls..

I need a VBA code to automatically revise this whole description when I put more vendor data...

Unfortunately, I'm not good at VBA material to make formula...

Actually, this is the first time...

so, anyone knows any sugestion, let me know a.s.a.p...

Thanks...