Changing the way relative references in formulas are adjusted when copied

J

Jana L.

Hello

I have a very basic formula in cell B3 of a worksheet.
This formula contains a reference to cell B9 in a
different worksheet (same workbook). I would like to copy
this formula three columns across, to cell E3. This
normally adjusts the relative reference in the formula to
cell E9. Here's the rub: I want the formula to reference
cell B10 (ie one row down, same column). And when I copy
the formula to cell H3 I would like the reference to
change to cell B11 (again one row down, same column).

Formula in cell: Copied to: I want it to change to:
B3 =Sheet1!B9 E3 =Sheet1!B10
H3 =Sheet1!B11
K3 =Sheet1!B12
and so forth

Is there any way that you can tell Excel how to adjust the
formulas when copied?

Thank you!
Jana
 
Top