I have a sheet in Excel that has many formulas and it gets the necesary inputs from a sheet called “inputs”. someone else is in charge of maintaining this “input” sheet.

Recently, the format (title and subtitles position, mainly) was altered and now all my formulas are wrong.

i need all the formulas in my sheet to reference 2 rows below what they used to. that is, the cell A1 used to reference cell AD315 from “input” A2 referenced AD316 and so on. under the new format A1 should reference AD313, A2 should reference AD314 and so on. the problem is that there are around a thousand references and changing them 1 by one would take way too long.

Is there a way to make all the references 2 rows lower without doing it 1 by 1?

i´ve been updating cell by cell but it is taking way too long.