7
7
78964672019-12-01 12:13:29
Google Sheets
7896467, 2019-12-01 12:13:29

How to pull information from several sheets into one?

How to make sure that within one table, information from all sheets is displayed on a separate sheet, it is desirable when editing this sheet, the information on the original sheets also changes.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2019-12-01
@7896467

You just need to specify a reference to the range and wrap it in an ArrayFormula ()
empty lines (in this case, by the first column)

=Arrayformula(
{
filter(Лист1!1:200;Лист1!A1:A200<>"");
filter(Лист2!1:200;Лист2!A1:A200<>"");
filter(Лист3!1:200;Лист3!A1:A200<>"")
}
)

Demo table

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question