How do I alphabetically sort list linked to other tables?
Is it possible that it is not possible to sort a list alphabetically, if it is linked via formulas to other tables? How to solve it?
[Re-Titled by Moderator]
iMac 24″, macOS 15.0
I'll try to explain it better.
I have a document with 65 sheets and 336 tables.
Made for the management of the summer camp.
In a sheet I have a database with the registry of the registrants even from previous years.
The camp lasts seven weeks so I have a sheet for each week that takes the list of names from the database with this formula
In the weekly sheet there are various columns where participation fees are marked such as weekly registration, lunches, trips...
To each weekly sheet are connected other sheets that with formulas (IF/OR)I'll try to explain it better.
I have a document with 65 sheets and 336 tables.
Made for the management of the summer camp.
In a sheet I have a database with the registry of the registrants even from previous years.
The camp lasts seven weeks so I have a sheet for each week that takes the list of names from the database with this formula
In the weekly sheet there are various columns where participation fees are marked such as weekly registration, lunches, trips...
To each weekly sheet are connected other sheets that with formulas and filters make lists of those present at lunch, or on the trip or other activities.
These lists show the name it takes from the weekly sheet and the phone number it takes from the database
In each weekly sheet there are also hidden columns that allow me to automatically fill in graphs, lists by year of birth and more.
When I add a new member to the database, this name is also included in the weekly sheets.
If I order the database, the weekly sheets are also ordered but only in the name column: the other columns remain fixed. and filters make lists of those present at lunch, or on the trip or other activities.
These lists show the name it takes from the weekly sheet and the phone number it takes from the database
In each weekly sheet there are also hidden columns that allow me to automatically fill in graphs, lists by year of birth and more.
When I add a new member to the database, this name is also included in the weekly sheets.
If I order the database, the weekly sheets are also ordered but only in the name column: the other columns remain fixed.
I'll try to explain it better.
I have a document with 65 sheets and 336 tables.
Made for the management of the summer camp.
In a sheet I have a database with the registry of the registrants even from previous years.
The camp lasts seven weeks so I have a sheet for each week that takes the list of names from the database with this formula
In the weekly sheet there are various columns where participation fees are marked such as weekly registration, lunches, trips...
To each weekly sheet are connected other sheets that with formulas and filters make lists of those present at lunch, or on the trip or other activities.
These lists show the name it takes from the weekly sheet and the phone number it takes from the database
In each weekly sheet there are also hidden columns that allow me to automatically fill in graphs, lists by year of birth and more.
When I add a new member to the database, this name is also included in the weekly sheets.
If I order the database, the weekly sheets are also ordered but only in the name column: the other columns remain fixed.
It is a complex document, but working in everything, except for the possibility of having the last members in alphabetical order.
