you could, in the cell in Sheet2, enter = and use your mouse to point to the
cell in Sheet1 hit enter and the cell should now have formula which looks like
=Sheet1!C3 or
=Sheet1!$C$3
(assuming the sheet nane is Sheet1)
note if here is a space in he sheet name there mae be some apostrophies
='Sheet 1'!C3

"McLearning" wrote:

In Execel how do I apply data from a cell on sheet1 to cell in sheet2? For
example, If I want the sum total from cell c3 on sheet 1 to display in a cell
on sheet 2.