Vlookup Macro(VBA) One Sheet to another or One Workbook to another

Every month I have to gather data from different locations into "Master sheet" and the same data need to be updated into a "month workbook" consist of work sheets eg. April, May, June....So on.
I do not want to manually type VLOOKUP formula every month. "CUSIPS" are the reference(unique) here in "master sheet".If the cusips in "master sheet" matches one that is in " month workbook" then I want the information in column B, C D& E from "master workbook" to be put in B, C, D & E of "month workbook".

In short, IF the cusips in "Master sheets" are exact or exist in "month workbook" then all the relevant data from "mastersheet" need to be updated in "month workbook".

I am totally confused to built a code for the situation although its looks simple when i do it by manually but I want this in macro(vba).


Any help or guidence will be much appreciated.

Hi and welcome to the forum,

Could you upload a sample workbook?
And what do you mean by CUSIPS? Is it a named range?

Hello , Thanks for looking out for the above problem.
Here cuips means a "looks up value" common in both sheets that is master sheet and month workbook and from which we are searching and updating data.
Here is the example. I want all the master data need to be updated in month workbook every month. this is just a short data but in real the data is very huge and every month I have to vlook up from master workbook to 4 different workbooks. Kindly suggest me a vlookup vba code. thanks a lot

Master Workbook
cusip, beginning, principal, interest, endbalance
123, 10000, 1000, 50 , 9000
789, 8000 , 400 , 150, 7600
245, 5000 , 1000, 200 , 4000
456, 4000 , 1000, 1000 , 3000
789, 2500 , 500 , 100 , 2000

Month Workbook(April)
cusip beginning principal interest endbalance
123
789
245
456
786