Update Data Automatically

[niladri20052006]

My name is Niladri and I want your help for center query in excel.

1. I have 2 files of excel and one master file. I want to automatically update the master file when I change into any file from 2of files.


2. If I change the location of master file then the link of other files in master file should be update automatically.


Thanks in advance!

 

[kpark91]

Hello,
I believe if you want it to be updating automatically.

I think VLOOKUP function as a formula will help out a great deal.
However, setting your calculation setting to automatic would be crucial for automatic update on your master sheet. (I've done a similar project but checking row and column and transcribing the data regardless of the column position)

As I do not know what this quote means, I don't really know what you want.

2. If I change the location of master file then the link of other files in master file should be update automatically.