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
|
Similar Threads
