Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display cell based on multiple cross-references | Excel Worksheet Functions | |||
Cross sheet references (=Sheet2!B4) | Excel Discussion (Misc queries) | |||
formula references vertical cells in a separate worksheet | Excel Worksheet Functions | |||
Cross worksheet references cannot be easily changed | Excel Discussion (Misc queries) | |||
Excel-value in a range of cells for two cross references | Excel Worksheet Functions |