I'm trying to extract data from a list that meets certain criteria and put that info into a new list. If you look at the attached example the 2nd tab has registrations. Based on the registrations I would like to create separate lists for each group. Column A has which group they will be in. I would like the first name, last name and date of birth for everyone from Group 1 from the 2nd tab to show up in columns B, C, and D in the 1st tab "Evaluation- Group 1". Hopefully that makes sense after looking at the example.
If possible, it would be nice to have it broken up by gender as well. So I would create another tab, 1 with "group 1 female" and another with "group 1 Male".
Thanks for any help!
Bookmarks