| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Link to a cell in another workbook by name rather than absolute c.
I need to get data from a total cell in one worksheet into a cell in another
worksheet. Because the source worksheet will have lines added to it, I wanted to reference the cell by its row and column label (e.g. "Jan Sales"), rather than by an absolute cell reference. I tried several variations and keep getting the #REF and #NAME errors. Does anyone know how to do this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
| Why am I unable to link a cell in one worksheet to a cell in anot. | Excel Discussion (Misc queries) | |||
| How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
| How do I link many cells to one particular cell? | Excel Discussion (Misc queries) | |||
| I am trying to link based on a text value instead of cell position | Links and Linking in Excel | |||
Threaded Mode
