I am trying to create this attendance template.
What formula or VBA code to use if Audit and Risk word chosen from drop down menu then it will automatically populate the list of attendees.
Then, if another word chosen from the drop down list then automatically populate the list of attendees the bottom empty cells (continue from the previous lists)
Attendees master data is in Sheet2
please help me on this.
I have attached the spread sheet.
THANK YOU in advance