Copying Formula across Sheets

[Dave]

How do I copy an Excel formula that I've created (just a
simple two-cell multiplication) that involves cells on
two sheets so that it repeats down a column on one sheet?
When I try to do it, the cell on the other ("non-
dependent"?) sheet is made a constant. Instead, I want
corresponding cells on both sheets to be multiplied. For
example, Sheet 1, Cell A1 * Sheet 2, Cell D4; then Sheet
1, Cell A2 * Sheet 2, Cell D5; then Sheet 1, Cell A3 *
Sheet 2, Cell D6; etc. Thanks!

 

[Gord Dibben]

Dave

On Sheet1 in cell B1 enter =A1*Sheet2!D4

Drag/copy down Sheet1 column B.

A1 will increment to A2, A3 etc.
Sheet2!D4 will increment to D5, D6 etc.

If you are entering on a third sheet, it would be entered as

=Sheet1!A1*Sheet2!D4

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Dave]

Thanks!

-----Original Message-----
Dave

On Sheet1 in cell B1 enter =A1*Sheet2!D4

Drag/copy down Sheet1 column B.

A1 will increment to A2, A3 etc.
Sheet2!D4 will increment to D5, D6 etc.

If you are entering on a third sheet, it would be entered as

=Sheet1!A1*Sheet2!D4

Gord Dibben Excel MVP - XL97 SR2 & XL2002