Update automatically the content from all files of workbook, when make changes in one of them

[vladimiratanasiu]

Hello!

I have a workbook including more files with data about some companies, as shown in the next Dropbox link : Sales.xlsx . Each file include a column with the same companies, thed could get supplementary data (e.g. sales, products etc., depending the). At one time, one / more rows with companies could be added / deleted in a file. My question is how could be automatically updated the content from all files, when are made changes in one of them. At the same time, if is added a new company I need the content of its corresponding row auto arrange alphabetically, based of the supplier name.

Thank you in advance.

 

[Fluff]

Duplicate to: Updating new content alphabetically in the main file and the

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.