Can this be done? Several workbooks updating information in one "master workbook"

[bergvall88]

Hi!

At the moment we are collecting order statistics that is put in a single workbook from different departments. The data is seperated to seperate workbooks which contains information related to different deperments. They then make comments and and edit information in their own seperate workbook. Each row have their own unique index number.

At the moment I manually copy-paste everything back and fourth. I am wondering if it is possible to write a macro that opens each other workbook (or maybe more preferably the one you choose) and then looks for the index number and then replaces cells or the entire row in the master workbook with the information from the other different workbooks.

Seperating the information in the firts place I have done using Query.

Any thoughts about this setup and if its even possible?

Thanks in advance.

Best regards

Fredrik Bergvall