I want to build admin worksheet that contain one big table crated from many other tables in other excels files. How should I go about it? How to link many tables into one without blanks and lost of data?
Info:
- All tables have the same headings.
- All tables contain different number of rows
- Admin collect (see) all data, user can see only his/her data.
- Any updates made in User table automatically changes table in Admin worksheet.
- All files will be hosted online in OneDrive (that is why I can't use VBA)
- List is sorted by date, order depends on the date column
- Many users, one admin
To give you better idea of what it should look like I create the chart.
[How it should look like (Structure)]
Ideal solution, would be to somehow connect tables into one table, so that it will automatically update. I looked for many different solution in formulas but none of them worked. Can not link it because number of rows will be changing and increasing. I can not properly connect those tables.
Sample headings for table:
Purpose of the table is to have a list of all customers that are added by salesman.
Info:
- All tables have the same headings.
- All tables contain different number of rows
- Admin collect (see) all data, user can see only his/her data.
- Any updates made in User table automatically changes table in Admin worksheet.
- All files will be hosted online in OneDrive (that is why I can't use VBA)
- List is sorted by date, order depends on the date column
- Many users, one admin
To give you better idea of what it should look like I create the chart.
[How it should look like (Structure)]
Ideal solution, would be to somehow connect tables into one table, so that it will automatically update. I looked for many different solution in formulas but none of them worked. Can not link it because number of rows will be changing and increasing. I can not properly connect those tables.
Sample headings for table:
Purpose of the table is to have a list of all customers that are added by salesman.
