Hi All,

My primary objective is to validate few datas from 4 to 5 different excel workbooks(using vlookup function) based on that I will prepare consolidated report.

It's a daily activity every day I'm opening the same file(but updated).

I want to know do we have any formulas to open the file and vlookup using the formula? If yes I can update the formula alone in my consolidated report.

Please help me on this!!!


Regards
Elango