| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Relative Cell References When Linking
I have a very large master spreadsheet with links to data in 5 other
spreadsheets. How can I avoid linking the cells one by one (from the master to each of the 5), as I have noticed that copying a link formula does not automatically update the cell reference? I am looking to save some time and manual labor! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Relative Cell References When Linking
Fri, 6 Jul 2007 14:26:04 -0700 from TraciB
: I have a very large master spreadsheet with links to data in 5 other spreadsheets. How can I avoid linking the cells one by one (from the master to each of the 5), as I have noticed that copying a link formula does not automatically update the cell reference? I am looking to save some time and manual labor! INDIRECT will help. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Relative Cell References When Linking
I'm not sure I understand the syntax. Here's the link from the master sheet:
'D:\data\PMO - Global Application Outsourcing\Initiative Tracking by Unit\[PMR Template-NA.xls]NA'!$L$23 How do I use the INDIRECT function here so that $L$23 becomes $M$23, etc. when I copy? Thanks much! "Stan Brown" wrote: Fri, 6 Jul 2007 14:26:04 -0700 from TraciB : I have a very large master spreadsheet with links to data in 5 other spreadsheets. How can I avoid linking the cells one by one (from the master to each of the 5), as I have noticed that copying a link formula does not automatically update the cell reference? I am looking to save some time and manual labor! INDIRECT will help. -- Stan Brown, Oak Road Systems, Tompkins County, New York, USA http://OakRoadSystems.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Relative (vs. Absolute) Cell References with macros | Excel Discussion (Misc queries) | |||
| How to copy an array without changing relative cell references? | Excel Worksheet Functions | |||
| F4 key does not toggle relative/absolute cell references. | Excel Worksheet Functions | |||
| Relative Cell References within VBA code | Excel Discussion (Misc queries) | |||
| Transpose-relative cell references would be useful. | Excel Worksheet Functions | |||
Linear Mode
