Copy Values from Excel Form

Copper Contributor

I have been tasked with developing a new system to track evaluations. The idea I am using is utilizing Microsoft Forms and excel to simplify entering data. This works well, but particular data from the form I would like to split into sections (attendance, comments on performance, and mental health status).


My goal is to organize attendance by week and particular names so that they filter accordingly. I also want it to have a function that automates, so as the form fills with more data, it is auto-entered into the appropriate fields. I've tried a multitude of functions, but I haven't been able to narrow it down. I've attached a few pictures to show how the data laid out.  Thanks to all that help.






3 Replies


The pivot table works in this scenario,I think.

Unfortunately that doesn't work since it summarizes values instead of showing the actual value.