Hello dear all, I have a workbook that has 2 excel sheets.
On the 1st sheet, I have an excel spreadsheet which includes the list of teachers by line and the classes they keep. So on my second sheet, I created a dropdown list of teacher names as well as a second dropdown which will be responsible for retrieving each time the list of classes kept by this teacher. Do you have any idea how it works?
Try the attached using 'structured tables' - all the data and choices you make stay within the confines of the table - there is no need to extend the data validation this occurs dynamically as the tables expand/contract.
Look in the 'name manager' to understand the process - the teacher name list is taken from the table headers - then a relationship is established between each column and an index is established to determine which column is read into the subject list.
Refer to the data validation setup and you will see the reference names that are called for the list of each validation.
To start the table first put a 'full stop' (point) in cell 'A2' move to 'B2' and back to 'A2' then make your two choices - to extend the table repeat in 'A3'>'B3'>'A3'
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks