Linking worksheets

  • Thread starter Thread starter Blackstone63
  • Start date Start date
B

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
 
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.
 
Back
Top