How To Copy Data Across Sheets In Seconds

Hi guys, welcome to this session in Google Sheets. In this module, want to show you quick way of getting data on multiple sheets by using simple formula. So, I've got four sheets in this example, four, three months, and then total sheet. So, I'm going to type some information on January, and then want that to be replicated on all the other sheets. Now, in Excel, could use the grouping feature, but in Google Sheets, there is no feature for that. So, I'm going to have to use this method. So, if start in cell two and type week one and then just pull that across. So, I'll get five weeks and then total like so. And I'll just do income, expense, and balance in column So, income, expense, and balance. And then I'll do little formula in here, which is just going to be equals that cell minus the one below it, that one. And press enter on that. And then just get zero. There's no figures there. Pull that across. And then here want to do the sum function. Click on the sum function and it doesn't pick anything up. But if highlight that space and press enter, it should pick that up. And then pull that one down like so. And then all of this needs to be into pounds. So, highlight all of that. Click on the pound sign. And also want this formatted slightly different to this. So, if highlight that area there, go to the little paint pot and select orange or something. And if highlight all of this, want to put borders on. So, I'll click on borders. want all borders, that one. And then just need to do title. Call it sales and marketing. Sales and marketing. And then want to have that merged and centered in the across the top like that. Like that. So we've got it merged and centered. So that's all want on that sheet. So now need to link it up with the other ones. So if go into Feb and start in the top and just type equals and then come back to Jan and click on the title and press enter on that. That's brought that in. Now should be able to pull that down and then you can see it picking it up there. You get the idea. Come across like that. So, it's bringing that up and then across again. It's bringing that up. I'll have to do the merge and center bit again. Just center that. Merge that as well like so. And then put the formatting back on. So, it's slightly quicker than typing it out all the time, but it's obviously not as good as what Excel is because Excel would have actually done all that in one go, which would make this lot easier than than it is now. So, to pick different color and then the same thing is going to be done on March. So, I'm just going to type equals. Doesn't matter which one go for. Go down for January. Click into this center cell. Press enter. And then pull that down. and then pull it across. Come down too far, but it doesn't matter. won't bother coloring this one in. And then the total sheet is going to be the same. So, equals, go down to Jan, click on the cell you want, press enter, and then pull it down, let go, and then across, and then let go. Okay. So once you've done that, there's few things you need to fix. need to get rid of these two columns first of all. So want to highlight column and and want to delete these two columns. Right click, delete columns, and want to change that to Jan. Pull that over to Feb and March. And then just need to delete these two off that I've done already. So that's okay. But what you've got here are formulas. So you see these formulas because we copied the whole sheet. So basically need to get rid of all these formulas. I'm deleting that. And this formula need to do it again. It just needs to look at this row here. These three. Press enter on that. And then pull that one down like so. Now, this one is also looking at formulas. So, need to redo this again. So, going to be equals that minus that. So, basically what you're doing, you've got you've got the format correct. You're still going to have to come and do the formulas and make sure that's all correct. So, the these are all how it should be. Now, make that into pounds and those two into pounds. Should have highlighted the whole thing. Actually, the whole thing should be in pounds. So on each of these ones that we copied, so January should be okay. I've just typed 10 and five there. So check that works. But there's no formulas in this orange area. But there is on February. All of this is linking through. So need to delete it off. And need to do the same on March and then redo March as well. So there's no formulas there coming from January. Get rid of them. And then just redo those formulas here. so February that's just going to be equals B3 minus B4. Press enter on that one. Pull that over. So it's quicker in terms of getting the formatting the same. You probably don't want to do the formulas to start with when you're doing this. In hindsight, probably shouldn't have done the formulas because they're now taking me longer to get rid of them. Pull that one down. Make everything into pounds. So that's clear. Pounds there. And then last but not least, March. So equals B3. B3 minus B4. Press enter. Pull that across. and then sum. Press enter on that. Pull that down. And then what we need to do is link it up. So if go pull that down, make all of that into pounds. Come back onto the total sheet. So the total sheet now needs linking up. So from here I'm going equals down to Jan. Clicking on B3. That's what want. Pressing enter. And it brings that through that10. Pull that down. That works. And that's picking it up. So do the same for Feb. Equals Feb. There's no figures on February. So could put some on there. Press enter. Pull that down. and then March equals down to March. Click on the cell you want. Press enter. Pull it down. Now on February and March, need to just type some figures in there to check this. So I'll just do it for week one. 10 for income, five for expense. Checking that the formulas are all working. Okay, I'll do this for March as well. 10 and five. 10 and five. So what you should get is on the total sheet you should get 3015. If go to the total sheet 3015. So that's right. So that's all want to talk about in this little video. Basically how you can get the same format on multiple sheets. Probably in hindsight like said already don't do the formulas on the sheets when you're doing it. It's mainly just for formatting but you'll get the layout the same and then do the formulas afterwards. So hopefully this little video is of use. Thank you for your time and I'll catch you on the next one.