---I am trying to feed data from a Google Form to a Google Sheet. I want to have it separate out each student into their own sheet. Then I want to sent that information back to the student in a Google Sheet so they can edit their work.
---From what I understand, I can make A QUERY for each student on their own tab, but they will not be able to edit the tab. So I researched and found out that I also need to IMPORTRANGE in order to share the Sheet so they can edit it.
EXAMPLE: I have tried this: =Query(Importrange("1w7lTxbg933A36rk0mNdqzaJn7KHAzXrvqekVXhh_BKM","Class January Work Log!A2:k"), "Select * where B = 'student's email address'")
My error message is this: Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: B
Basically, How do I receive the data from Google Form onto Google sheets and allow my students to edit it without other students seeing their work.