So I have a worksheet that has a main column of labels (apples, oranges, etc) and I add a new column every week with metrics for that week's data in that category. Then I display that week's data in a dashboard on another worksheet.
Can anyone help with with a formula to pull the metrics from the last column into my dashboard automatically without having to touch the dash?
Here's an example of what I want to do:
example.xlsxexample.xlsx
Bookmarks