How to link two files correctly?

[bncoxuk]

Hi Sir,


I have a file 'Master' which needs to fetch data from three columns of file 'Source'. Currently it is simply specified as linking to A1, B1 ...


What worries me is that if someone inserted new columns in the source file, the data fetched are wrong!


Can I ask how to use some formula to identify the columns for Year, Age, Status, so that the data are always read correctly even if the old file has changed with new columns added?


Thanks a lot for teaching.

 

[imgonna]

Hi


The simplest way is to protect the source files from changes so that this can't happen.


Cheers

Glen

 

[NARAYANK991]

Hi ,


The following two links discuss this topic , with several ideas :


1. http://www.dailydoseofexcel.com/archives/2010/04/16/creating-dynamic-names-in-vba/


2. http://www.dailydoseofexcel.com/archives/2010/05/04/creating-dynamic-named-ranges-in-vba-ii/


Narayan