Microsoft Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add hyperlink using sheet names and cells(i,j) 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0
If function across sheets prints value of cell 4
Sum 9
EXCEL - IF(IFERROR(VLOOKUP question 0
compare cells and sum if equal 4
product code a value 0
use month in cell date to sum all relevant cells 2

Back
Top