Hello,
When working with Microsoft forms, I need to be able to have the answers submitted through microsoft forms seperated in to separate files and by date.
For example: Jim submit a form on November 5th, and checks that his T-Shift size is Large. The data from that entry is plugged into the 5th cell of an excel sheet. (Due to it being the 5th day of the month) Then, Jim checks that he likes the color black. That entry is placed in a SECOND xcel sheet in the 5th cell. Jim decides a day later he wants another shirt, so he fills out a second form on Nov 6th for a Large Gray shirt. The size data from form #2 is placed in the 6th cell of sheet 1, and the color data is placed in the 6th cell of sheet 2. So on and so forth.
Pleasae advise.
Thank you!