Linking worksheets
 

Hi

I am pretty new to excel. I am trying to link information between
worksheets. I have a master sheet with costing information and subsequent
sheets with materials lists that reference back to the master sheet to give
me a total project cost. I am looking for a formula for the following
example.......E7 on sheet 2 should equal C7 on sheet 2 x D10 on sheet 1 x D7
on sheet 2.
Thanks for any help!!!

Charles

Linking worksheets
 

Hi,

In E7 enter

=C7*Sheet1!D10*D7

Note the easiest way to build this type of formula is to point and click.
In E7 type = then click on C7 type * click on D7 type * click on the sheet
tab for Sheet1 and then click on D10 in that sheet and press Enter.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Blackstone63" wrote:

Hi

I am pretty new to excel. I am trying to link information between
worksheets. I have a master sheet with costing information and subsequent
sheets with materials lists that reference back to the master sheet to give
me a total project cost. I am looking for a formula for the following
example.......E7 on sheet 2 should equal C7 on sheet 2 x D10 on sheet 1 x D7
on sheet 2.
Thanks for any help!!!
=C7*Sheet1!D10*D7
Charles

Linking worksheets
 

Thanks Shane I made this work.............................

"Shane Devenshire" wrote:

Hi,

In E7 enter

=C7*Sheet1!D10*D7

Note the easiest way to build this type of formula is to point and click.
In E7 type = then click on C7 type * click on D7 type * click on the sheet
tab for Sheet1 and then click on D10 in that sheet and press Enter.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Blackstone63" wrote:

Hi

I am pretty new to excel. I am trying to link information between
worksheets. I have a master sheet with costing information and subsequent
sheets with materials lists that reference back to the master sheet to give
me a total project cost. I am looking for a formula for the following
example.......E7 on sheet 2 should equal C7 on sheet 2 x D10 on sheet 1 x D7
on sheet 2.
Thanks for any help!!!
=C7*Sheet1!D10*D7
Charles