B
B
b3rg2020-04-14 21:50:19
excel
b3rg, 2020-04-14 21:50:19

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

1 answer(s)
A
Alexander Ivanov, 2020-04-15
@oshliaer

No way. It is necessary to iterate over the names of the sheets.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question