I have a very complex spread sheet with many years of data. Each year I need to roll it over to the following year. This means starting off with a new blank Yearly table.
I inherited the table the way it is.
Each year we add a new year to each of the Franchisee worksheets (in the example Adel, Airlie and Bay.) The way the spreadsheet is structured it is done at the top of the worksheets ( I don't know why). The problem is that this changes the cell references to point to the old data in the new location. Is there any way to prevent the cells from doing this. I have included a sample file and changed the first Franchisee worksheet to reflect the problem.
Here is the link