Good day all. Excel 2007.
I have (many) columns each displaying student data in rows below.
On a separate sheet I have a data validated sellection from a dropdown menu
of the students names.
What I am trying to achieve is that when a particular student name is
selected from the dropdown, the corresponding student data should appear in
fixed cells on the top rows of same sheet where the student name was selected.
The cells where the selction is made will move down the sheet row by row,
but the data should appear (now for the new student selected) in the same
fixed cells on the top of the sheet.
Hope this is clear and not too convoluted!!
Can anyone assist?