Open workbook basis given date minus 1 and extract corresponding values from that file and put it against the value

[James Clear]

I have one folder wherein Month wise files are stored ( for example in the month of Feb'22 - 1-02-22_1 & 1-02-22_1 )

for each date 2 files are stored , now I have Value let us ID in my excel with the date

For example - 573483 - 1-02-22 and so on and there are 300 to 500 entries so as per the date , I have to minus one from the given date and open that particular file and lookup columns against the ID and extract into my excel against my given IDS

So if Date is given 3-02-2022 , it will open file for the 2-02-2022 and extract values or lookup values from that file and paste into my file and close it and process will continue till the time my LAST ID has it's corresponding values.

Files which are saved at the folder from we are extracting values are vey huge in size.