Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2021, 12:55 AM
thomf thomf is offline Attendance Sheet Help! Windows 10 Attendance Sheet Help! Office 2016
Novice
Attendance Sheet Help!
 
Join Date: Apr 2021
Posts: 1
thomf is on a distinguished road
Smile 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
Reply With Quote
  #2  
Old 04-30-2021, 07:32 AM
Logit Logit is offline Attendance Sheet Help! Windows 10 Attendance Sheet Help! Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

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
Attached Files
File Type: xlsm Simple Database.xlsm (20.8 KB, 5 views)
Reply With Quote
  #3  
Old 05-01-2021, 11:30 AM
p45cal's Avatar
p45cal p45cal is offline Attendance Sheet Help! Windows 10 Attendance Sheet Help! Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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.
Reply With Quote
Reply

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft