as you mentioned I used query on the data I have and imported 2 sheets into another 3rd one, How to make it automation, when I type new info on 2 sheets it have to auto come in the 3rd one
Hi! This should be the default behavior as long as all files are open. There may be slight delay if you're collecting lots of data but not more than a few seconds I think.
a reallly superb tutorial - clear, comprehensive and very well paced - congratulations and thank you very much
Thank you so much, be sure to subscribe for much more content coming up! Take care :)
as you mentioned I used query on the data I have and imported 2 sheets into another 3rd one, How to make it automation, when I type new info on 2 sheets it have to auto come in the 3rd one
Hi! This should be the default behavior as long as all files are open. There may be slight delay if you're collecting lots of data but not more than a few seconds I think.
@@coupleracademy any way I did that, now I collects the data from 3 google sheets to one form
Thank you for the video. Could you also do one with IMPORTHTML in Google sheets
Thanks! Noted your request, we'll consider it when discussing future videos.
=QUERY({IMPORTRANGE(BX14,"NA!B14:BQ50");IMPORTRANGE(BX15,"K1A!B14:BQ50")},"select * where Col1 is not null")
It doesn’t work
Hi! Is there some error message? Have you authorized IMPORTRANGE to pull data from that spreadsheet?