I have simple query formula that pulls rows of data from one master sheet(A) to another tab(B), but like all query data I can't edit the data on the tabs(b). Is there a way to make the data editable and somehow linked to the master sheet(A)?
Ex.
On the master list I have the following
Jane Doe 555-555-444 [email protected] Student
John Doe 555-666-000 [email protected] Faculty
I have a tab(B) named student and one tab(C) named Faculty. My query simply pulls each row to either the student or faculty tab. But if I wanted to change the data on the student tab, I can't.