I run data through a program, and afterwards, it inputs the values to Microsoft Excel, displaying an 18 month table. The problem, however, is that data from several months ago might change randomly (be that from data changing, or a correction), and the goal is to keep the original values at what they were prior to changing (keep previous values historical to the months they were assigned). I will attach an image as an example. You will see the highlighted portion of what I would like to have change month by month when I generate the report, but I do not want the previous months to change.
So to sum it up, how can I keep previous cells static (for previous months), while just having the current month change. The tricky part will be having each new month bump the old one up the table, so to have all months move up one cell for the next month, while remaining the same.
Hopefully I am being concise enough here. I have seen some online suggestions about pressing F4, but it does not seem to work, especially when I am trying to move each month up the table to allow the new month's data to come in.