Hi sorry if I sound daft but Im a newbie to excel. I have a sheet called 'Staff' with 3 columns.
'Staff'
A. Surname
B. Shoulder No
C. Qualification Date
On another Sheet 'Dispo' I want to have a dropdown list with column A having a drop down using the data from Sheet ' Staff' column A "Surname" that when `I select the surname the next 2 columns populate with the 'Shoulder No' and "Qualification Date'
I hope that I have explained this properly.
Thanks in advance
Bookmarks