Hi 1st Time posting,
Sheet 1 has a table with 5 columns (Name (A1), Date (B1), Type of Occurrence (C1), Reason (D1), (Un)Excused (E1)), the fields are filled through questions through a user form. The contents will vary within a set number of values from the above mentioned.
On Sheet 2 I have...