Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What is the formula to reference a cell in a different worksheet?
Please help. I am trying to create a formula that uses a total from a
different worksheet in a specific cell that is not the same as the original worksheet that will contain the actual formula. |
#2
|
|||
|
|||
Jenny If you want to have a formula read a cell or value from another spreadsheet, the simplest way of doing this is to have both spreadsheets open. As a simple example, select a cell in workbook A (this is where the result of the formula will end up). Put an equals sign in this cell and before hitting enter, place the cursor into the other workbook (B) and click on a cell that contains a number. This has now linked the two workbooks so that as the number in workbook B changes, the formula you have created in workbook A (which will be something like =+[workbookA.xls]sheet1!$a$1 ) will change too. Once you get this bit straight, you'll find linking workbooks isn't really any different than connecting sheets in the same workbook Good luck Jon -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=476132 |
#3
|
|||
|
|||
Assume you have sheets called Sheet1, Sheet2, Sheet3, €¦
Say that the TOTAL you want is in Sheet3 in cell A30, and you want this to appear in cell A10 on Sheet1. In Sheet1, cell A10 press the equals sign (=), then with you mouse select Sheet3 and position your cursor in A30 and hit enter. Select Sheet1, in A10 you will find you have the value from Sheet3, A30. The formula should look like =Sheet3!A30 Hope this helps. Pank "Jenney Zellner" wrote: Please help. I am trying to create a formula that uses a total from a different worksheet in a specific cell that is not the same as the original worksheet that will contain the actual formula. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use cell reference instead of name in a formula? | Excel Discussion (Misc queries) | |||
Need Vlookup to work with formula in reference cell | Excel Discussion (Misc queries) | |||
reference a repeating cell in a formula | Excel Worksheet Functions | |||
Is it Possible in a formula to have a formula for cell reference? | Excel Worksheet Functions | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |