I have a spreadsheet that I'm using to track weekly performance metrics and want to create a summary page that only shows me the value of each metric for the current week.
The worksheet is currently set up with dates across the top in the first row and metric names down the side in column B.
My summary page is set up with metric names in column A and current value in column B.
I'm looking for a formula that will insert the present value of each metric based on the current date into the summary page. The dates in row 1 indicate the last date of the reporting period (Saturdays).
The name of the sheet where the data is being pulled from is "KPIs" and the full range of the data is C2:BB80 (C1:BB1 is the dates and A and B are metric categories and names)