Unfortunately I can't share an example sheet, but picture this:
Sheet 1 has a dashboard showing cost savings. I want cell B2 here to always show the current cost savings for this period.
Sheet 2 is a data sheet which has dates (months) in row 1. Cell A2 has our first month's cost savings, and cell B2 has our second month's cost savings. Column C, so in this case C2, containts averages for the various items we're tracking.
As more months roll in, I'm adding more columns between (in this case) column C on sheet 2. I've been manually updating these on the dashboard, but we're starting to track too many items to make this update efficient.
I need help having cell B2 on Sheet 1 show the values in the new cells in the new column on sheet 2 as I insert them. I want B2 to always show the most current (-1 column from the averages column currently occupying C) value.
Is this possible? I've read a little on OFFSET mixed with COUNTA, but I can't seem to make it work - I can add one column and it'll set up, but I can't get it to work when I continue to add columns.
Thank you!
Bookmarks