Search : in
By :

Spreadsheet/Cell Question for Excel

Last answer on Jan 22, 2009 8:03:59 pm GMT C, on Jan 16, 2009 7:02:15 pm GMT 
 Report this message to moderators

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.

Configuration: Windows XP
Firefox 3.0.5

Best answers for « Spreadsheet/Cell Question for Excel » in :
Spreadsheets - The Excel Interface Show Excel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Excel formula to get the cell with the text Show
Excel active cell macro Show
[Excel]Storage name and path of a spreadsheet Show[ExcelStorage name and path of a spreadsheet The tip below will show you how to automatically show the storage path and the name of any spreadsheet Enter in a cell (E.g cellA1) the following formula: =cell("filename", A1)...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Download Excel Viewer ShowExcel Viewer 2003 will allow you to open, view and print spreadsheet workbooks though you do not necessarily have to install Excel on your computer. Features: It will allow you to make a copy of the information found in Excel Viewer 2003 and...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Spreadsheet - Text Operators ShowConcatenation Operator Spreadsheets generally use an oeprator, called a concatenation operator , that allows two text values to be added together. The concatenation operator, written as &, is used as follows: In the above example, the cell...
Ask your question Reply

1

MS Trainer, on Jan 22, 2009 8:01:39 pm GMT

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.

   
Reply to MS Trainer

2

 MS Trainer, on Jan 22, 2009 8:03:59 pm GMT

This is called a 3D Reference

   
Reply to MS Trainer
Ask your question Reply
They need your help