nskinner821
New Member
- Joined
- Oct 29, 2019
- Messages
- 3
BLUF - I looked through the threads best I could and did not see this answer, so I am very sorry if this scenario has already been answered.
What I have is a workbook with 6 tabs (one "data" tab and 5 other tabs representing the days of the week). The data tab contains a list of 22 students names in the first column, with the next 5 columns each representing Mon-Fri. In the rows/columns I have a selection of 5 different activities the students will be participating in that day.
What formula can I use that once I select an activity in a cell for that corresponding student and day, it will automatically list that student under that activity on the next workbook tab (for that day?)
My goal is that I can use the "data" tab once a week and quickly select the task for each student by day. In turn, that auto populates on each one of the "day" tabs that will have the 5 activities listed as columns with the names auto-populating under each activity.
Thank you so much for any help.
What I have is a workbook with 6 tabs (one "data" tab and 5 other tabs representing the days of the week). The data tab contains a list of 22 students names in the first column, with the next 5 columns each representing Mon-Fri. In the rows/columns I have a selection of 5 different activities the students will be participating in that day.
What formula can I use that once I select an activity in a cell for that corresponding student and day, it will automatically list that student under that activity on the next workbook tab (for that day?)
My goal is that I can use the "data" tab once a week and quickly select the task for each student by day. In turn, that auto populates on each one of the "day" tabs that will have the 5 activities listed as columns with the names auto-populating under each activity.
Thank you so much for any help.