Dear Experts,
I have a googlesheet with 4 worksheet, I named them as
Source_1,Source_2,Source_3,Source_4 and I have a query below;
=QUERY({Source_1!A2:I;Source_2!A2:I;Source_3!A2:I;Source_4!A2:I},"select * where Col3 is not null",0)
Can anyone is kind to help me that my query will be dynamic when a New Worksheets is added?
Let's say I will add a new worksheet "Source_5" so the result I need from my Query formula would be;
=QUERY({Source_1!A2:I;Source_2!A2:I;Source_3!A2:I;Source_4!A2:I;Source_5!A2:I},"select * where Col3 is not null",0)
Can be this possible?
Thank you in advance.
12Rev79
I have a googlesheet with 4 worksheet, I named them as
Source_1,Source_2,Source_3,Source_4 and I have a query below;
=QUERY({Source_1!A2:I;Source_2!A2:I;Source_3!A2:I;Source_4!A2:I},"select * where Col3 is not null",0)
Can anyone is kind to help me that my query will be dynamic when a New Worksheets is added?
Let's say I will add a new worksheet "Source_5" so the result I need from my Query formula would be;
=QUERY({Source_1!A2:I;Source_2!A2:I;Source_3!A2:I;Source_4!A2:I;Source_5!A2:I},"select * where Col3 is not null",0)
Can be this possible?
Thank you in advance.
12Rev79