one of the best ways and, and most interesting ways to use import range is when I wanna have a sheet of data that's on a spreadsheet somewhere, on a tab, but I want it in a different spreadsheet file. So here, I am compiling a bunch of different spreadsheets from each month and putting them into a whole other spreadsheet . Now, the trick is I can absolutely go to my original data . I can click here, and I can copy to an existing spreadsheet. That is possible. And if I do that, it works. The sheet copies. However, if w- within, say, I wanna make some edits within some certain amount of time, those edits need to also be done on both pages.

So doing this, ah, copy to existing spreadsheet only copies the data and then never updates it, but import range will. So what I can do is I can get a brand-new sheet or- I can copy the format of a sheet and save that and then delete the data . And now in A1, I'm gonna do equals IMPORTRANGE . And what I need is two things. I need the spreadsheet URL and the range string, which is just the location of this sales tab and the range of cells, but I'm gonna show you how to do that. I'm gonna take the URL, put it in here, and then I put that in quotes. Make sure you put that in quotes or you're gonna get an error. And now the range string is going to be in quotes as well, and it's going to be Create a Public Sheet and Private Sheet: Using ImportRange()

just the tab name, so in this case it's all caps SALES, plus a exclamation point, plus the range of cells that I want. And I think I only want A1 to G13, but maybe I don't know that it's to 13, so I can just do A colon G here, and that means that I'm gonna get every single row from A to G. I'm gonna hit Enter. And one thing I need to do is I'm gonna get a reference error . I need to highlight or select this and Allow Access . That is very key. But now I can go back to my original data and say, oh, I mistyped this. This was supposed to be twenty-one, twenty-two. Now I go back to my yearly and it is updated. I do not have to update both sides of this.

However, one rule of thumb is the data is one way. If I try to edit anywhere here, if I'm like, "Oh, this is also wrong," put in a thirteen, oh, I get a reference error because it's trying to expand data over this. Am I trying to write in here? I cannot. One thing I can do is after I use IMPORTRANGE , and I do necessarily want to not have any data go back and forth, I can click A1, do Command+C and Shift+Command+V or paste values . Now that import range is gone, so it is not sending new information But at least I can edit this sheet. But I'm gonna leave that there in this import range and see here, I can do Sync Two Tabs Without ImportRange()

import range , and just making sure you remember that it's got the entire URL and then the tab name, exclamation point, and the range of cells you want. You can do very specifically A1 to G13 if you want. Totally possible to do a very specific range of cells . Now, in my case, I am taking the original data , moving it into this second sheet on a different spreadsheet file, and I am putting it in the same place, the same columns, the same rows that it's in the other one. But you don't have to. That's actually one of the coolest parts of import range, is that I can actually put this import range inside of another spreadsheet without being the exact same cells.

I just need to make sure I have the correct cell range size, like this right number of rows and right number of columns. I can create a single dashboard on a single tab that brings in a lot of data from other spreadsheets. I think that's really cool, and I think that's a really cool use case of import range , that I can take individual cells from other spreadsheets, pull them into here, and I can update those other spreadsheets, and it updates this sort of dashboard in and of itself. Really cool. I think import range has a lot of opportunities. If you're using import range, comment down below how you're using it, what you're doing with it, and if you have any problems, let me know. I'm happy to help You're watching Better Sheets here on YouTube. Watch this video or this video. It's gonna make your Google Sheets better Go ahead, ask me anything down below in the comments.

And I'm going to answer it in a future video become a member of Better Sheets today. . You get videos, you get sheets. So what do I have to do to get you into a brand new Google Sheet? Go buy some tools that I've built inside of Google Sheets doing things in Google Sheets you never thought possible. Go check it out