Copying Formula across Sheets

  • Thread starter Thread starter Dave
  • Start date Start date
D

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!
 
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
 
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
Click to expand...
 
Back
Top