File with selections

Hello,

I would like to create an excel spreadsheet that will extract from a data base sheet with various columns : name,category and group I would like to extract this information in another spreadsheet with the possibiliyt to do different sélections on different days and post it on the main sheet after doing a selection.

The choice wouls be wich category would you like to work on today, and another choice would be what group would you like to work on today. I would like to be able to make more then one choice per day. then the selected information would print underneath that day in the yellow area.

I have attached a sample file, very basic just so you can understand better what I would like to do.

Can you help me as to what formulas I can use to help nme with this project?

Thank you very much in advance.

AttachmentSize
Exercice.xlsx18.7 KB