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
Re: Attendance Register
try to read about INDEX / MATCH or VLOOKUP
I want to see what you are trying to achieve, not how you are trying to do it
What makes learning so hard is the amount of knowledge you have to unlearn
Why is my program not doing what I expect?
Because you set the wrong expectations. Rewire your brain
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By asifprpt900 in forum Excel General
Last Post: 07-16-2017, 05:31 AM
By kurtyranks in forum Excel Formulas & Functions
Last Post: 11-29-2016, 06:15 AM
By hongman in forum Excel General
Last Post: 11-10-2016, 06:03 PM
By MinieMe209 in forum Excel Formulas & Functions
Last Post: 03-17-2016, 05:34 AM
By switzd0d in forum Excel Formulas & Functions
Last Post: 02-17-2015, 03:00 PM
By Crumm in forum Excel General
Last Post: 08-25-2005, 09:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1