How to import data from other files to one excel report.

[Sobitas]

I have an excel file where I have several rows of data.
I want to be able to update that file with the information I have in 2 different excel files.
The idea is to be able to update the rows of the master file if any change is detected on the other two files.
Is it feasible?

Regards

 

[Nebu]

Hi:

This is possible , as you have not given much of the details about your data as a general solution you can do this using lookups.

Thanks

 

[Aby]

if you use vlookups and under links if you specify the source file then every time you open the file then you will be asked if you want to update values from the links. pls try

 

[Lymm]

If you still need help you may need to upload a sample file so as to get a more precise answer.

 

[Vivek D]

You could do that with Power Query. This is probably one the most common use cases for the Power Query addin.