Answer the question
In order to leave comments, you need to log in
Pull data from one of two related IMPORTRANGE Google Sheets?
There are two related functions IMPORTRANGE Google tables
table 1 and table 2.
In table 2 there is a calculator with data entry,
in table 1 all internal calculations are carried out, the results of which are then displayed in table 2.
Let's say I have editor access to table 2, how to get data from all sheets from table 1?
With which communication is configured, but there is no direct access to it.
Details:
If you make a new empty sheet in table 2, enter =IMPORTRANGE(table code; "range") there without a sheet name, then I will automatically get the data of 1 sheet, but how to get the data of the remaining sheets if the sheet names are not standard "Sheet 2 ", "Sheet 3", etc.
Answer the question
In order to leave comments, you need to log in
No way. It is necessary to iterate over the names of the sheets.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question