Hi, so I work for multiple clients and store their data updates on the same excel file. And I have a column "client" that specifies which client is dealt with in this specific row.
The clients have the same workbook, but only with their data.
I am looking for a way (hint, method, maybe software) to be able to connect my workbook with my clients' workbooks so that:
-The changes I make will be updated in their workbooks, but only the changes with their name in the column "client"
-their changes to be updated in my 'consolidated' file
-The clients should not have access o other clients' data, so no access to my whole workbook
Do you have an idea how can I do this?
Thanks
Bookmarks