I am trying to do an attendance tracker for about 900 people. These people will be divided into 30 people to 30 rooms. Column A will be a dropdown menu with the room numbers and column B will then return the list of people in that room. I would then like Column C to have a drop down menu with Absent/Present/Late/Excused options.
Does this require a macro or can it be done with data validation. If anyone could steer me in the right direction I would appreciate it.
Bookmarks