vladimiratanasiu
Active Member
- Joined
- Dec 17, 2010
- Messages
- 346
- Office Version
- 2021
- 2019
- Platform
- Windows
Hello!
This problem is somehow alike my previous post, but with different results. I have a workbook including more files with data about some companies, as shown in the next Dropbox link : 1. Lista Furnizori Agreati.xlsx . The file "Furnizori" includes all companies, arranged alphabetically. Each other file (A,B,C etc.) includes only the the group of companies from file "Furnizori", whose names start with the alphabet letters (A, B, C etc.). 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 the file "Furnizori", when are made changes in other files, adding or removing new / existing companies and auto arrange them alphabetically. Similarly, if a company is added / deleted from the file "Furnizori", I need to be operated the same changes in the file where the company/ies is/are placed. At the same time, depending of the changes, all elements should auto arrange alphabetically also in the main file and in the letter-marked one(s).
Thank you in advance.
This problem is somehow alike my previous post, but with different results. I have a workbook including more files with data about some companies, as shown in the next Dropbox link : 1. Lista Furnizori Agreati.xlsx . The file "Furnizori" includes all companies, arranged alphabetically. Each other file (A,B,C etc.) includes only the the group of companies from file "Furnizori", whose names start with the alphabet letters (A, B, C etc.). 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 the file "Furnizori", when are made changes in other files, adding or removing new / existing companies and auto arrange them alphabetically. Similarly, if a company is added / deleted from the file "Furnizori", I need to be operated the same changes in the file where the company/ies is/are placed. At the same time, depending of the changes, all elements should auto arrange alphabetically also in the main file and in the letter-marked one(s).
Thank you in advance.
Attachments
Last edited: