Answer the question
In order to leave comments, you need to log in
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
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<>"")
}
)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question