Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-10-2012, 10:39 AM
joneckenrod joneckenrod is offline linking cells between files when cell address changes Windows XP linking cells between files when cell address changes Office 2003
Novice
linking cells between files when cell address changes
 
Join Date: Feb 2012
Posts: 4
joneckenrod is on a distinguished road
Default

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.
Reply With Quote
  #2  
Old 02-10-2012, 02:07 PM
joneckenrod joneckenrod is offline linking cells between files when cell address changes Windows XP linking cells between files when cell address changes Office 2003
Novice
linking cells between files when cell address changes
 
Join Date: Feb 2012
Posts: 4
joneckenrod is on a distinguished road
Default Changing the cell "name"?

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.
Reply With Quote
  #3  
Old 02-10-2012, 11:37 PM
Catalin.B Catalin.B is offline linking cells between files when cell address changes Windows Vista linking cells between files when cell address changes Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 02-13-2012, 07:04 AM
joneckenrod joneckenrod is offline linking cells between files when cell address changes Windows XP linking cells between files when cell address changes Office 2003
Novice
linking cells between files when cell address changes
 
Join Date: Feb 2012
Posts: 4
joneckenrod is on a distinguished road
Default

Thanks. I appreciate it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
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
linking cells between files when cell address changes Make Cells Mimic The Formatting Of One Cell skoz55 Excel 1 11-09-2011 09:00 AM
linking cells between files when cell address changes Linking text from an embedded sreadsheet cell spheon Word 2 05-26-2011 01:03 PM
linking cells between files when cell address changes How to combine different cells data in one cell? Learner7 Excel 1 07-28-2010 12:07 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft