Select/update/retrieve cells between Excel files

Hi please I need help. I want to use an excel file named for ex:Contracts as my workbook this file contains this cells: model, interval, KmC.
And other excel files as source of data, here is what I want to achieve in

steps:

1- In Contracts when I write model name in B1 the system should choose the file with the same name. nothing will happened just picking the right workbook for the rest.

2- when I write kmc B2 it should be updated in a given cell in the right workbook that has same Model name.

3 - same think as step 2

NB: after updating these values the amount and tax will change in the model file that we are working with.

4 - now I want to retrieve the amount and tax in the workbook that has the same name of the model that we write in the first step.



Please I need guide for what I have to use in each step or what I should learn in the future to do those kind of things: exchange data between file, Data manipulation. Create word documents from excel.

Thanks in advance

You could do something like:

Please Login or Register  to view this content.

2- when I write kmc B2 it should be updated in a given cell in the right workbook that has same Model name.

This isn't clear on if the Contracts workbook is updated or the Model workbook is updated

The example will show you one way to react to a cell's change and open a workbook.

Good luck with your project, hopefully, you can use this to figure out the rest.

Thanks man I appreciate your help

You're welcome, good luck with your project.