I am trying to create a formula with a relative
reference. I want to name a cell like BEGCELL. Then I
want to be able to calculate based on the row of that
cell. For example my first formula will be =BEGCELL +
(BEGCELL+16 rows same column) then my next formula will
be =(BEGCELL+20 rows same column) + (BEGCELL+36 rows same
column) and so on.
What I'm trying to acieve is that if my row number
changes I only have to make one change and the rest of my
formulas will adjust. Thanks for the help.