Hi all
I am trying to create an attendance register for weekend trips.
I have the following colums
ID No., Surname, Forname, Gender, NOK, Contact Number
I have 2 sheets one has all the personnel details on and the other is just headings.
What im trying to do is if I enter the ID No. for one person the other colums will automatically add the details for that person.
Can anyone help please
Bookmarks