I'm working on a Google Excel doc which is being populated by entries on a Google form. Each row on the sheet relates to one form entry.
I'd like to self-populate a separate sheet for each row which will be easier for a committee to read. I have created the layout for the individual sheets and assigned which data from the main sheet fills each field, however changing it on each sheet takes a long time. Is there a way to designate each tab when I create it so that it auto-fills all of the correct data from the correct row on the main page?