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!