updating rainfall data

JulioAu 

Hi, I am trying to find a quickest way of updating a large rainfall data from month to month, without the need to drag or manually fix the formula.

Example, updating data for 2023, for January Decile 1 (Historic Deciles for Period to January), I click the formula and the January column is highlighted, normally I will just extend the blue box to include 2023. And then I have to do the same for the rest of the months.

QUESTION: is there another way to do this?

Answer: Yes. In fact, there are probably many ways to do it.

One observation, though: the images present what some might describe as an unfortunate mixing of Input and Output, attempting to collect and display the data in the same place.

In my opinion, you'd be better served by creating

• a single comprehensive database, the purpose of which is nothing but collecting the raw data at the input end
• a "dashboard" or output sheet that displays the averages, totals, deciles --whatever summary data are desired

That separation of input (and data storage in a well-defined and designed Excel Table) from output would enable you to take advantage of Excel's many methods of extracting data from a database; moreover, it would enable the formulas to remain constant as they'd "automatically" take into account new months and years of data.

This would require what is probably fairly minimal re-arrangement of your current data, since much of it already--at least what can be seen in your images--IS tabular in nature. 

Is it possible--assuming the data are not proprietary or confidential--for you to post a copy of your workbook on OneDrive or GoogleDrive, with a link pasted here that grants us edit access? (Being able to actually see the real workbook is far more informative than an image.)