ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Microsoft Excel (https://www.excelbanter.com/excel-worksheet-functions/105510-microsoft-excel.html)

McLearning

Microsoft Excel
 
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.

bj

Microsoft Excel
 
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.



All times are GMT +1. The time now is 03:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com