Forum Discussion
Increase the cell reference in a formula by 38 rows
Hi. I have a worksheet with many formulas in a column which are linked to another worksheet via formulas i.e =AW!$D$499, AW!D$500, AW!$D$521 etc...). I have been manually adding 38 (the number of ...
Charla74Hi
Thank you for your reply. Unfortunately it didn't work. Nothing happened to the formula when I dragged it to the right (I even tried removing the $ on the cell number reference).
The cell reference (on AW) is a 'Yes' or 'No' and copies that into my sheet. Each column is 38 rows down on the previous formula.
Thank you again for trying my friend
It shall be offset calculated on columns, like
=OFFSET(AW!$D$499,(COLUMN()-COLUMN($A$1))*38,0)