Connect different Google Sheets files, and choose any column with IMPORTRANGE

In this video I will show you various methods to bring only certain columns from a different file in Google Sheets
➤You can find the template from this video in my patreon page, where you´ll also have priority responses to your questions
practicalsheet...
You can also join my academy practicalsheets.com, where you´ll find, not only the templates for this and all the videos, but also Google Sheets Courses, technical service, and more
➤You can also subscribe to the channel where you´ll find a new Sheets video every week.
Here are some of the places where you can follow and support me:
➤Patreon: practicalsheet...
➤Webpage: practicalsheet...
➤Newsletter: practicalsheet...
➤Telegram: practicalsheet...
➤Facebook: practicalsheet...
➤Twitter: practicalsheet...
Any suggestion, question or insights, feel free to comment below

[@heart2hertz]

Wonderful tutorial tbh!! But i suggest to change the video name better so that it shows to people who also search for "how to connect all sheets" or anything around that. Because i have been searching tutorials and all i could find was harder ways or which is not much apt kind of videos. Im glad i could find yours because you have explained every basic and major needs.

[@practicalsheets]

Thank you for the suggestion!!
Kind Regards

[@kidsCartoonloverofficial]

Thanks for such a wonderful video, one query,how to use more than one filter, as you have used Japan using "where'

[@practicalsheets]

Try it this way
WHERE Col5='Japan' OR Col5='India'
Kind Regards

[@user-vp8hy5ov5x]

Hi thank you for this video, it was very enlightening on how to pull certain columns from a source sheet to a destination sheet using Query and Import Range. However, what I am struggling with is if the columns change in the source sheet (ie. I add columns) it throws out what is being pulled into the destination sheet. Is there a way around this? So the selected columns being imported into the destination sheet stay the same even if the column numbers change in the source sheet? Thanks!!!!

[@practicalsheets]

Hi!
I think this is the wrong video ;)
MAybe you could use a formula such as choosecols, but still it would have the sme problem I think
Regards!