I'm not even sure this can be done, but I'm giving it a shot. The picture below is a snip of the sheet I'm working on. I'm wanting to figure out if there's a formula that will put the data from a single cell on the Sep row to the "Current Month" row - but the catch is that is needs to look for the last numerical data in the column so that when I input the number for Oct it will update the Current Month row to the new number.
I hope that makes sense. This is so I can have my dashboard automatically update instead of me having to go in each month an update what row the dashboard is pulling the data from.