Do you mean have the contents of a cell on one sheet appear in a cell on another sheet?
If so, it's easy if both sheets are part of the same workbook.
1. On the second sheet, highlight the cell you want the data to appear in, to link TO.
2. Enter an equal sign in that cell to start the formula, then use your mouse to switch to the first sheet and click on the cell that has the data in it already, the cell you want to link FROM.
3. Press ENTER.
4. Your cursor will return to the link TO cell and you will see that it now shows the data from the link FROM cell.
That's the simple explanation. Here's the formula explanation.
For one cell (A2) to show the contents of another cell (A1), the formula you enter cell A2 is =A1
That works if the cells are both on the same sheet. If they are on separate sheets, you simply have to add the name of the sheet and and exclamation point to the formula.
Sheet1, cell A1 is the data cell.
On Sheet2, in cell A2 enter the formula =Sheet1!A1
Whenever U want to link two different sheets to each other follow the following...
Copy the data whatever U want to link "the data" to another file or sheet,then,
Select the desired cell where U want to paste the data and then press Alt+E+S+L and the Enter.
I would like to connect 2 excel spreadsheets within the same workbook I want sheet 1 to be a shipping record that can be edited and printed out and sheet 2 to track the data in sheet 1. Basically what I want is the data in sheet 2 to automically track the changing data in sheet 1 is this even possible?
Most things are possible but your question isn't clear.
It would be preferable for you to post your own question into a new thread of your own, attach your workbook where you have manually mocked up what you're trying to automate and point out where you'd like help.
Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.
I am using Excel 2007. I want to put the calculation part or the detail figure in one sheet. And I want to put the relating pi chart or some other graphical representation on some other sheet.
How I would relate these two sheets so that when I make any changes in the figure in the first sheet...
The Sharpe Corporation: Detailed cash flow budget for the first seven months of 2004
The Sharpe Corporation's projected sales for the first eight months of 2004 are as follows:
I am creating a "Table of Measurements" for a moving company in Excel, and they require that in the "# of pieces" cells that a number "1" or a similar character be placed in the cell rather than a "2" for two pieces or a "3" for three pieces, etc. So if there are 4 pieces, the cell would have...