Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 02-13-2012, 01:12 PM
zyzzyva57 zyzzyva57 is offline linking cells between files when cell address changes Windows 7 32bit linking cells between files when cell address changes Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

Just a thought, but wouldn't it just be easier and wiser to have a worksheet called "Absolutes" to link into

This way, your other workbooks and worksheets will reference the same location, while you insert and delete rows without worrying about the location of your Absolutes located in one referencing worksheet usable with all workbooks

For example, a tax rate that several cells all over the place uses will always stay correct in its Reference to a tax rate or any other things that never change, or than, say, the rate from 5% to 6%

If so, you go to Absolutes, make the change(s) and move on knowing all references to the tax rate has been updated


Reply With Quote
 



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 09:29 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