Please Watch this video to learn that how to create dynamic Attendance Sheet with Formula, VBA and Conditional Formatting. You can also find the support formula and Excel sheet in the description of video:
https://youtu.be/6xp2gDXaRqchttps://www.youtube.com/playlist?list=PLD6BcxtIn1r2P3L4d3HbnzUbAhjFdiiwT
