Attendance Sheet Help!

thomf · #1 04-30-2021, 12:55 AM

Hey all,

This is my first post, so I am sorry if it is a silly one, but I'm looking for some help.

I have built a training programme primarily using Microsoft Forms (or, alternatively, if training is delivered in person then the participants will complete a Form for feedback) and I have got this to sync with Excel; dropping their credentials and answers into the spreadsheet.

If, on sheet 1, I have a list of names and user ID's who should have completed/attended the training session and on sheet 2 I have all this data being fed into excel by the people who *actually* attended (thus, completing my "Form") - is there any function that could either highlight or simply put a Y or N into a column for "Attended?"?

Any suggestions would be most appreciated!

Have a good day, y'all and take care.

T

Logit · #2 04-30-2021, 07:32 AM

Here is code from a simple database project. It can be utilized to accomplish your goal. Of course you will need to make a few changes to the code to accurately perform in your project :

Code:

Option Explicit
Private Sub btnCancel_Click()
    Unload Me
End Sub

Private Sub btnOK_Click()
    Dim ws As Worksheet
    Set ws = ActiveSheet
    Dim newRow As Long
    
    newRow = Application.WorksheetFunction.CountA(ws.Range("A:A")) + 1
    
    'The next two lines can be expanded as many times as needed for all the entry fields in your project
    
    ws.Cells(newRow, 1).Value = Me.txtFirstName.Value
    ws.Cells(newRow, 2).Value = Me.txtSurname.Value
    
End Sub
Sub CommandButton1_Click()
    Selection.EntireRow.Delete
End Sub

p45cal · #3 05-01-2021, 11:30 AM

Yes you can, easily, but in tables you need to use indirect references
2021-05-01_192010.png
with a formula:
2021-05-01_192542.png
but this is very basic conditional formatting and based on guesswork.
Best to attach a workbook with both sheets and we can add working conditional formatting which will cover more columns of highlighting.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Need a formula to help track attendance	westendj	Excel	1	07-13-2017 11:44 PM
Attendance Analysis	LarryLee87	Excel Programming	4	11-23-2016 05:14 PM
Export meeting attendance to .csv/Excel	danieljoachim	Outlook	0	02-05-2015 06:44 AM
Create an attendance sheet for monthly club meeting	jcc285	Word VBA	0	08-30-2014 09:34 AM
Automate Office Attendance	kgwack	Outlook	0	02-14-2012 09:39 AM