VBA for Vlookup and Paste

[dyeung1]

Hello,

Very bad at VBA but hoping to get some assistance with this one. I want to insert a macro function that does a vlookup/indexmatch and extracts data from the file "ZMRDA03" from each respective column, based off the data in column M in the "Plant RDA Register_DY" excel file and pastes them into the columns N-AA within the "Plant RDA Register_DY" file.

See attached some snippets for your reference
Thank you,
D

 

[James006]

Hello,
Have you tried to turn on your macro recorder .... and go through your process once ...