Hi Everyone,
I have been looking for a while and cannot seem to find a solution. I am creating an "application" we will use at work when we host youth conferences. I have a UserForm in place that collects participant data and places it into a sheet in the workbook. This sheet is called ParticipantData. What I need to do is be able to generate another list on a separate sheet that separates the males and females into two separate lists on a separate sheet titled, Dorm List Report. On the ParticipantData sheet the fields I want captured are First Name(A), Last Name(B), Age(C), Gender(D), and School(I). I have attached the workbookCopy of Conference Tracking Workbook.xlsm for review. Thanks!