I am currently working on a Sheet file that allows to register people. Each person corresponds to a line and it is necessary to assign different data (in relation to each other). To facilitate the input of this information, I have chosen to use drop-down menus.

For exemple, if you choose a certain value as the first data, I want to see only the values corresponding to this choice appear in the second drop-down menu. So I have a file that holds the records and another where the data to be assigned are written (