Apply Vlookup formula in all the available sheets in a workbook

[DocAElstein]

Hi,
In the next macro version here, http://www.excelfox.com/forum/showth...ll=1#post11828 , I have modified it so that it will try to open a file that has the name like "MSCI Equity Index Constituents " & [a date one month earlier than the date on the current file]

What it does basically is:
It looks at the date in the name of the current file, (the current file is the file from which the coding is running )
It then makes a string source book name which contains the date for one Month before the date in the name of the current file.

So if you run Sub MakeFormulas4() in the attached workbook, "MSCI Equity Index Constituents 20191231.xlsm" , then it will open a workbook saved in the same folder with the name "MSCI Equity Index Constituents 20191130.xlsm" ( "MSCI Equity Index Constituents 20191130.xlsm" is then what you refer to as your source book )



I don't understand the rest of what you are asking in your last post.


Alan