Multiple Worksheet Formulas

  • Thread starter Thread starter blhlambd
  • Start date Start date
B

blhlambd

How do you write a formula in 1 worksheet that contains data in another
worksheet? Both worksheets are in the same workbook.

Thanks for the help!
 
Perhaps this in a cell in sheet 1

=22/Sheet2!A1

now put a 7 in a1 of sheet 2 and your sheet 1 cell will now read 3.142

Mike
 
=IF(Sheet2!A1=7,...

as a simple example

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
OK, let's try again. I am in 1 workbook. I am trying to take 1 cell in 1
worksheest that has a function of summing a cloumn of about 10 cells. I want
that auto sum to show up in a different worksheet. I want the updated total
to reflect in both cells without having to go throught the update cycle of
closing the workbook, etc.

Please help.
 
Back
Top