Linking worksheets

[Blackstone63]

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

 

[Shane Devenshire]

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.

 

[Blackstone63]

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