![]() |
|
#1
|
|||
|
|||
![]()
I suppose you are right, but I hope not. I really can't attach any files that would reveal the complexity. There are hundreds of part numbers, and periodically, part numbers are added (not in sequence), and it makes the most sense to insert them in between other part numbers. But when that is done, it changes the cell addresses of all cells below. And those cells are linked to 6 or 7 other excel files that use their data. I was really hoping to be able to keep the accurate information flowing even when cell addresses change. If you or anyone else has any suggestions, it would be so helpful.
|
#2
|
|||
|
|||
![]()
Will changing the cell "name" from an address to a "name" cause the information to flow through even when the cell address changes? This may be elementary to most of you, but I really am a novice and would like to know if this can work. Thanks.
|
#3
|
|||
|
|||
![]()
Both files A and B must be opened;in source file B, place the cursor in cell F29, go to the Insert menu, then choose Name, and then Define from the expanded menu . Enter a name, like F29FileB (no spaces), ( in refers to box you will already have =Sheet1!$F$29 (assuming that the source cell F29 is in sheet1). press enter. We are done with source file.
Now, in destination file A, define another name , could be the same from source: F29FileB, clear everything there is in the refers to box, then switch windows to source file, click on cell F29; now, in refers to box, you will have ='[File B.xls]Sheet1'!$F$29 which must be edited to the name defined in source: ='File B.xls'!F29FileB (or , from the insert menu , Name-use in formula, i think this is the step in your version of office). At this moment, in the destination file A, on a cell you can type =F29FileB then press enter (use it in formulas, like =$C$2+F29FileB ). You will have the value from fila B in that cell, which will follow that cell, no matter how many rows you insert in source. |
#4
|
|||
|
|||
![]()
Thanks. I appreciate it.
|
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking Word files | Aitch | Office | 1 | 12-29-2011 03:12 AM |
Naming a cell then linking with a certain amount of charachters looses content. | shabbaranks | Excel | 1 | 12-27-2011 01:06 AM |
![]() |
skoz55 | Excel | 1 | 11-09-2011 09:00 AM |
![]() |
spheon | Word | 2 | 05-26-2011 01:03 PM |
![]() |
Learner7 | Excel | 1 | 07-28-2010 12:07 PM |