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)?
On the master list I have the following
Jane Doe 555-555-444 firstname.lastname@example.org Student John Doe 555-666-000 email@example.com 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.