- Dec 23, 2013
|Hi there. I am a toastmaster. My group decided that we would use a spreadsheet to sign up for roles on meeting dates. Accordingly I want to have the users fill out a userform to indicate|
which dates they are interested in which roles. I have sheet1, which is seen below: It is a series of roles in the first Column (A2:A11) and a series of dates in the first Row (B1:J1).
The userform allows users to pull dates from a dropdown box. The form submits the dates along with their username to sheet 2. Sheet 2 is seen below. It contains Name, Time of entry and
the roles in the first row (A1:L1). Simple enough. What I need is the function that will be entered into the cells of sheet 1 to list the usernames for the respective dates and
roles as determined by the data entered in sheet2. Any takers?
Here's my sheet 2:
|Submitter||Time Submitted||Toastmaster||Ah-Counter||Word of the Day and Grammerian||Timer||General Evaluator||Speaker #1||Evaluator #1||Speaker #2||Evaluator #2||Table Topics Master|