Referencing a cell [that updates with the date] to a sheet from another workbook [that has that particular date] and then referencing a column. So when it goes to a new sheet in the worksheet, it will reference a column and a cell within the column...
So I was doing VLOOKUP and INDIRECT, but I dont want to manually do anything (if that makes sense).
=VLOOKUP(D2,'[PC-SCHEDULE.xlsm]Jul19'!$AC$9:$BD$39,28,FALSE)
^---I just want this to update(the Jul19' (thats from the separate workbook)).
Bookmarks