Excel worksheet customization
Budget: $30 – $100 USD
Please bid accordingly. I am attaching everything needed to complete the task.
Need an Excel worksheet that selects from multiple drop-downs.
The first sheet is the Activity Sheet, where we would see three different drop-downs. The first drop-down is the activity name, the name comes from the Activities Data Sheet column A. All others drop-downs must be disabled, if possible.
After selecting an Activity Name, we can enable the participants and office held drop-downs.
In the participants drop-down we want to be able to show all names and grades that are in the current Name Sheet. We should be able to select multiple names, and we would like to filter by grades. So I only see names related to that grade.
For each name I should be able to select an option from the office held drop-down. For example, if I select Test Name 1 and Test Name 2 from the participants list, then I should have an office held selection for Test Name 1 and another for Test Name 2.
After selecting Everything. I want that selections saved to another sheet, let’s call it the “report sheet”. The report sheet should contain one row per participant. Each row should contain the selected activity name, the office held, and the participant ID. See current example on that sheet.
Need an Excel worksheet that selects from multiple drop-downs.
The first sheet is the Activity Sheet, where we would see three different drop-downs. The first drop-down is the activity name, the name comes from the Activities Data Sheet column A. All others drop-downs must be disabled, if possible.
After selecting an Activity Name, we can enable the participants and office held drop-downs.
In the participants drop-down we want to be able to show all names and grades that are in the current Name Sheet. We should be able to select multiple names, and we would like to filter by grades. So I only see names related to that grade.
For each name I should be able to select an option from the office held drop-down. For example, if I select Test Name 1 and Test Name 2 from the participants list, then I should have an office held selection for Test Name 1 and another for Test Name 2.
After selecting Everything. I want that selections saved to another sheet, let’s call it the “report sheet”. The report sheet should contain one row per participant. Each row should contain the selected activity name, the office held, and the participant ID. See current example on that sheet.