Hello. Thank you for your support!
I have a list of data (tasks) that are assigned to specific individuals. I then has a sheet per individual.
I would like the task to be accomplished copied/filtered to the sheet for the individual selected.
This below is a secondary request that is not required, but would be nice.
Then, in their sheet, they have a drop down for if that task has been accomplished. They have a simple Yes/no drop down.
I would like that to be copied back to the main sheet for each task.
I have tried to convince my boss that there are better ToDo apps that are more tailored to this type of task, but he is set on using excel.
I can include a sample excel file with manually moved data to show what I am trying to do. I keep trying different methods and keep failing.
