Create two tables on the same sheet?
gaethang
Posted messages
2
Status
Membre
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello everyone!
I would like to take a couple of minutes to find a solution to my problem...
I am currently creating a list on an Excel spreadsheet that consists of two parts: one bringing together the members of my organization and the other the referents of the organization’s actions. It is important that we keep these two parts visible on the same page (so we cannot simply create two separate files).
The spreadsheet is online and each member must sign up themselves, which means that the rows need to be regularly sorted alphabetically. However, in doing so, the rows dedicated to the organization's actions and their referents also get moved.
Since this is a fairly flexible and self-managed process, it's not possible to be behind each person while they reorder the rows (I imagine it is possible to select the rows to put in order).
I therefore want to isolate the two parts so that sorting the rows dedicated to the members does not affect those dedicated to actions, but without having the second part end up in another file or another tab.
Do you have any solutions?
Thank you very much!
I would like to take a couple of minutes to find a solution to my problem...
I am currently creating a list on an Excel spreadsheet that consists of two parts: one bringing together the members of my organization and the other the referents of the organization’s actions. It is important that we keep these two parts visible on the same page (so we cannot simply create two separate files).
The spreadsheet is online and each member must sign up themselves, which means that the rows need to be regularly sorted alphabetically. However, in doing so, the rows dedicated to the organization's actions and their referents also get moved.
Since this is a fairly flexible and self-managed process, it's not possible to be behind each person while they reorder the rows (I imagine it is possible to select the rows to put in order).
I therefore want to isolate the two parts so that sorting the rows dedicated to the members does not affect those dedicated to actions, but without having the second part end up in another file or another tab.
Do you have any solutions?
Thank you very much!
Otherwise, there is a "protect the row" function, but it asks me to enter data. Is that a solution?