Previous Topic Next Topic

Spreadsheet/Cell Question for Excel

Closed
C - Jan 16, 2009 at 02:02 PM
 MS Trainer - Jan 22, 2009 at 03:03 PM
Hello,

Can someone help me? I have an Excel spreadsheet with multiple sheets. FYI, I have renamed the sheets (for example, Sheet1 is now "Calorie Intake"). I am keeping track of my calories on one sheet. In cell "C80", of Calorie Intake, I have a sum for all of the calories that I intake and I want to take the result of that cell and put it into another sheet (which I have renamed from Sheet2 to "Week 2 Intake"). I want to put the contents from Calorie Intake, Cell 80 and place/refer them into the sheet, in cell B3, which I renamed Week 2 Intake.

1) Is this possible?

2) What is this called?

3) What are the steps to do this?

Thank you in advance for your assistance.
Related:

2 responses

Answer 1 / 2
MS Trainer
Jan 22, 2009 at 03:01 PM
C,
Click the cell on your sheet two where you want to paste the information.
Type = (the equal sign), then click the tab at the bottom of your first sheet and click on the cell that has the data in it. Once you have clicked the appropriate cell, press your [Enter] key and the results will appear in the cell on your sheet two.
0
Answer 2 / 2
MS Trainer
Jan 22, 2009 at 03:03 PM
This is called a 3D Reference
0

Similar discussions

Keyboard troubles
jimbobjoe -
car -

38 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response