00:00okay imagine this you need to consolidate data from q1 to q4 from four separate worksheet into
00:05worksheet 410 initially you add the sole quantity from q1 to q4 worksheet and copy paste the formula
00:12across the column and then the rows for large scale spreadsheet this becomes impractical as
00:18the process become more laborious and furthermore the formula becomes more complicated with numerous
00:24worksheet there's a simpler way to do this and here's how you do it you start out by going to
00:28cell b8 here and you're going to say equal sum open parenthesis and you go to q1 select this cell
00:35here and then you hold down your shift key and press q2 q3 and q4 worksheet here and close parenthesis
00:42and hit enter and then apply the same formula right across the column and to every row with this method
00:48the formula is a bit simpler and easy to manage compared to the previous method
Comments