If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
cross references to cells in a worksheet
I use cross references (ref field) in my Word form templates to pull table
cell entries to other locations in the form or other pages. I can't find anything in excel help pointing me in the right direction for using cross references in an excel form that I am setting up. Is there a similar method? I want to identify specific cells in sheet 1 and have sheet 2 or 3 or 4 (however many additional sheets) pick up and reflect the entries made in the sheet 1 cells...... assistance is really appreciated Lenny |
#2
|
|||
|
|||
cross references to cells in a worksheet
Excel isn't a word processor and doesn't have things like cross referencing
as does Word. If you want the value from a cell in one sheet to show up in a cell in another sheet, you set up a formula to point back to the source data. Let's say you are on Sheet2 and want to get the value from Sheet1, cell A19. In a cell on Sheet2 you could manually enter the formula =Sheet1!A19 But it's probably easier to let Excel do the work for you: Start by going to the cell where you want your 'cross reference' and simply type in the = symbol. Then choose the other sheet, and the other cell and hit the [Enter] key. Excel will build the formula for you. This even works for setting up links between workbooks. "Lenny" wrote: I use cross references (ref field) in my Word form templates to pull table cell entries to other locations in the form or other pages. I can't find anything in excel help pointing me in the right direction for using cross references in an excel form that I am setting up. Is there a similar method? I want to identify specific cells in sheet 1 and have sheet 2 or 3 or 4 (however many additional sheets) pick up and reflect the entries made in the sheet 1 cells...... assistance is really appreciated Lenny |
Thread Tools | |
Display Modes | |
|
|