Your first three rows don't have vlookups, I'll assume that was just a typo. So what you want is for code that looks at the cells in column A and if they were the day before today then copy the vlookup results in that row and paste the values on top of the formula thereby replacing the formula with whatever the value was?
The reason I ask is your vlookups reference a file path so we have no way of knowing if these formulas change values as the dates change, which would mean we would have to, through code, manipulate the formula to have the value it did the previous day before turning the results into just a value in the cell.
I'll assume you want to just look in column A and whatever the formula results are for today those are what you want.
Bookmarks