I would want the different proportions of area planted (planting) given in row 23 on the Assumptions tab(not shown) multiplied by the hectares planted given in row 26 of the Assumptions tab as shown on the snippet. Now the offset function works fine for this but what I want is for the figure of the planted area to change(given in row 26) when I get to the month of July in each new year to assume the value of the area planted in that year maintaining the proportions adopted from row 23 in the Assumptions tab as I drag the formula without manually copying and editing it,something like a when loop (if there's something like that)