Narrow down info on one worksheet to a summary on another worksheet

[secretary]

Hi and thanks for reading.

I have a register of say 100 names who have ticked to attend a number of say 30 dates. Each individual will have chosen different dates. Names are in the first column, dates and days are in the top row and cells are filled with a y if attending.

I would like to break this register down to new worksheets that summarise, say all the participants who may be attending on the Mondays and call the new worksheet Mondays.

Can I make a new worksheet fill in the names that have a y in the boxes under the columns headed Mondays on the main sheet?

Hope this makes sense and thank you if you can help.

Helen

[ufopilot3]

Why not sort the list by date, then filter all the "Y" for that date. This should give you the answer.
If you want to post a sample of the worksheet, I'm sure there is another way to have a page summarize all the attendees by date.

HTH