I need a way to type the name in A10 from the list of names starting in I2 and make the corresponding list to that name to show in B10, B11… Sorry if that`s a basic question
New OpenDocument Spreadsheet.ods (7.6 KB)
It’s not hard to do, but hard to explain in detail: to understand this, you have to learn about Data - Validity and the MATCH(), OFFSET() and TRANSPOSE() functions.
New OpenDocument Spreadsheet.ods (27.3 KB)