Macro to copy value based on name

I have names in Col A and values in Col D in a workbook called Vat account balances (source workbook)

I would like a macro to copy the values in the source workbook to Col G in the destination workbook (paste special values) where the name in Col E (destination workbook) matches the name in Col A (source workbook)

Eg if name in A3 = Br1 and the value is 600,015 (source workbook) and E320 = BR1 , then 600,015 must be paste valued special in G320

I have also posted on Mr Excel.com


Macro to copy data based on name in Col A

Use Vlookup function in Excel. VBA solution is not necessary.

Look at this link on Vlooup syntax MS Excel: VLOOKUP Function (WS)

Hi Alan

Thanks for the reply. The Vlookup function , which I am familiar with is fine, However, there is a formula in Col D in the source workbook. I have several sheets for each month in the destination workbook and don't want the value updated. I want it to remain constant

Howard