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

"blhlambd" wrote:

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!

=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)



"blhlambd" wrote in message
...
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!

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.

"Mike H" wrote:

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

"blhlambd" wrote:

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!