#1
|
|||
|
|||
Attendance Sheet Help!
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 |
#2
|
|||
|
|||
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 |
#3
|
||||
|
||||
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. |
Tags |
excel 2013 formula, forms, formula help |
Thread Tools | |
Display Modes | |
|
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 |