+ Reply to Thread
Results 1 to 2 of 2

Attendance Register

  1. #1
    Registered User
    Join Date
    01-19-2018
    Location
    west midlands, england
    MS-Off Ver
    365
    Posts
    1

    Attendance Register

    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

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be everywhere
    MS-Off Ver
    All on PC except 365
    Posts
    9,887

    Re: Attendance Register

    try to read about INDEX / MATCH or VLOOKUP
    sandy
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Attendance Register using time formulas
    By asifprpt900 in forum Excel General
    Replies: 17
    Last Post: 07-16-2017, 05:31 AM
  2. School Attendance Register- Calculating for half day withdrawal
    By kurtyranks in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-29-2016, 06:15 AM
  3. Attendance Register with Excel?
    By hongman in forum Excel General
    Replies: 3
    Last Post: 11-10-2016, 06:03 PM
  4. Replies: 10
    Last Post: 03-17-2016, 05:34 AM
  5. Need Help - AutoCalculate Attendance Points for employee attendance records
    By switzd0d in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-17-2015, 03:00 PM
  6. Can a register automate a memo for none attendance?
    By Crumm in forum Excel General
    Replies: 1
    Last Post: 08-25-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1