So, I have 2 Google sheet, each has 7 tabs (different cities but same columns) in it. I want to transfer data from sheet 1 to sheet 2 by a copy feature or autofill. Autofill like once I filled the unique id (from sheet 1) in sheet 2 form, the common fields should autofill. All the coulumns in sheet 1 is present in sheet 2 but sheet 2 has extra columns too. Please Help me!!
You may wish to take a look at the referencing / dereferencing between tables.