Brilliant mate. I was on the right path, but getting stuck, and this clarified exactly what I needed. I'm going to do this first in excel, letting the business areas update their own data in locked-down sheets, then load the single appended file to Power BI for an extremely lightweight and quick report.
Right!!!!! I went through so many videos on Power Pivots, and then I find this one, in a couple hours, I get to build a beautiful Power Pivot Table. Thank you so much !!!
Allan, believe me when I see that my eyes nearly popped out of my head at 9:20 !! This is excellent info and exactly what I needed to combine two sheets containing future and historical timesheets for my team.
This was great! After watching many other videos that just confused me, I was finally able to combine multiple excel sheets from your instructions. Some of my data across sheets were redundant so I thought that after appending them (combining them together) I'd have to go through and manually remove duplicates. To my surprise, either there weren't any duplicates to start (rare) with OR this process removed the duplicates, saving me from a lot of tedious work. Superb and many thanks!
Thank you. Really easy to listen to. I struggle with my attention but your style and voice is engaging enough for me to take this information in. Thanks!!
Thank you. I learned a lot from this. From new raw data that I need to amend until I get what I want from huge multiple of worksheets. Combined and pivot has been made my life easier.. Head up, buddy!!!!
Hi Allan, thank you: well explained. One tip: add a new column to the queries: for exmaple: "France" , in this way you can later analyze per country. As to the question of Salam Miah: you can do this in regular Pivot: add the country in page filter and then you can make a report where all countries are displayed per sheet.
You BEAUTY. Iv been trying to find a method of combining a credit card and debit card tables/worksheets to track transactions for specific categories and sub categories...Finally.
You're very welcome Anne. Great to hear. I just uploaded a new video about appending data from multiple worksheets - ruclips.net/video/_uQDxzLPNbo/видео.html
Alan - another clear and most helpful video! Question though: wouldn't it be to your advantage (in terms of using a pivot table for analysis) to include the country name (UK, France, Spain, Italy) as an additional column for each individual table and then do the steps for an Append Query? I ask because once you have set up your worksheet that has ALL tables combined and then proceed to create a pivot table, you don't have a way to differentiate between the four countries....hopefully that makes sense! Anyway, I follow your RUclips channel regularly and find your help invaluable. Thank you!!
Hello, this is perfect, exactly what I was looking for. I am switching over from using Google Sheets and I am struggling a little with some of these minor things like combining sheets into 1 which is very simple in Google. I am wondering if there is a way to have your combined worksheet Refresh automatically or would i need to do a VBA code to do that?
Thanks for the useful video, however in my case the connection only tables does not read all the rows from my actual worksheets. if totaling all the rows in my worksheets are 100, then the appended worksheet shows me only 20 rows. How to resolve this?
Great video. Thank you. I have a very large excel file that I would like to append small amounts of data to without opening the large file. I process monthly data and then would like to save it to a file that contains all data. Up to now, I open the large file and manipulate it, which is time consuming. Is there a way to do that?
This was incredibly helpful! I am having a problem with long account numbers turning into scientific notation (E+) though. I went to the original source data and added an apostrophe before the account numbers but the account numbers are still showing as E+ numbers. All cells are formatted as text. Any ideas for how to fix this?
Sure. This example works as the data is within the same sheet. If the sheets were from an external workbook, then we would need to consider the file path and access when sharing.
Thank you, Debbie. Don't be scared. Power Query is fantastic. I have a couple of videos on your suggestion. Here is one - ruclips.net/video/9ljqozOVEWY/видео.html
This was incredibly helpful! Do you have any videos on how to use this new master table to add new data to all the source tables? I'd like to use this consolidated view to add in quote and delivery information without having to go to each table individually. Thanks :)
Sure. You would have other queries/tables reference this master table (lookup referencing queries in Power Query). And these queries can then be filtered to only show what you want. There is also the new FILTER function that can help with this in Excel 365 - ruclips.net/video/kdl3mNEyIRE/видео.html
Hi ! Great video, I am wondering what you would advise in terms of extra steps to perform, should each tabs contains different columns contents while the end goal is still to combine the specific columns data from the different tabs (in my case, i have for example 20 stock on hand reports from various locations, that have various different columns) as i am only interested in getting into the master tab: the location the sku is stored, the quantity, and of course the sku code). Thanks!!
Thank you so much for your videos, they have helped me immensely. Question regarding Append in Power Query. I have a template where I utilize a dropdown list in several columns. I noticed when I change the worksheet to a table, that option disappears. Is that correct? Is there a way to keep the drop down options? Thank you in advance for your help!
This is a great video thank you! I am curious if anyone know if there is a way to set this up so I can edit the information on the combined table and have it make those changes to the original tables? thanks so much!!
Thank you. You would want to reverse this process if you need it the other way around. You can create multiple tables/queries that reference the big query. Then filter each one so that it only shows the info you want. Any changes to the big one, when refreshed would then update the other queries.
Thanks a lot. It is working great!. Question. How can i share this file with others. I tried copying the file into the others computers, but got an error refreshing data. Am I missing somthing? Thanks in advance
Thank you. You can copy the file just fine. The issue with refreshing is probably an issue with the filepath that gets coded into the Source step. The recipients of your file would need to edit this to their filepath to the files.
Hi Good explaination. Can u please share a video which shows how to append from different sheets of diffrent worksheets from different workbooks not from different worksheets from same work book.. imagine in your example if france sales data is in combine -sheets.xlsx and spain sales data is in Spainasales_combinesheets-sheets.xlsx
@@Computergaga For example, you have 1000 numbers in one column and you want to analyze them to find some patterns, such as consecutive numbers, duplicated numbers, etc.
Thank you for this nice video , you have described how to combine files under each other having same column headers. But how can i combine files having same rows , beside each other ??
Thank you for your video! I learned something again. My next problem, I have 60 sheets, very time consuming to convert them all to table and transform the data. Any help on this? Thanks.
Hi Allan, this was really great! do you have any video with explanation how we could add new sheet to existing query? i am struggling right now with it and any support would be more than welcome. :-)
Thanks, Milan. You can edit an existing Append query to add a sheet. Open the PQ Editor and select the query. In the Applied Steps on the right, click the gear icon next to the Append step to edit it and add the additional sheets to append. Hope that helps.
Superb Is it possible to do same for multiple workbooks in a folder those are having multiple sheets. If new data added in existing workbooks or new more workbooks added, will it automatically update.
So today i learned something new about the Append Query feature. At first, i thought this was beneficial because it connects tables together. However, now i see it does a little bit more than just that. It creates value in the sense that once we have an append query set up, we could use it to save time. We could save time with it by removing the reoccuring step of having to rearrange a table due to differences in how columns are aligned. Again, this shows how using power query could be thought of as a more straight forward or user friendly approach to lookup. With a lookup function, i could have it extract data from specific columns. The issue with this is that if i am using column numbers as my return array, there's a very high risk of getting the wrong info returned to me in the event that the column number changes. however, when i use named labels, could i reduce the liklihood of incorrect data. It seems like the append query feature reduces that need to constantly have to rearrange the columns without having to learn the complex lookup functions.
This video was very helpful, thank you so much! one further question - is there a way to also add a column with the name of the worksheet or Table that the data are pulled from in the Append/combined version? Eg, an extra column that would show the row was from France or Spain, etc.
Subject is very good, let me test and come back to you, if successful and I expect, will save time especially when you did this with tenths of sheets hugely data 🙏
Thanks, how to add the country column in the appended list from the table names, so that it will be easy to see which sales is related to which country.
Thank you. I don't have this file anymore, but you can just create a few sheets for practise. They don't have to be large, just a few rows to get the techniques down.
Thank you, Pierre. The data is not provided for this video. I just did a search on my system and looks like I've removed the file. But you can practise this with any sheets. Any dummy data would work for practise.
Thank you! This is very useful. I have a question please. Is it possible to append data coming from other tabs into columns instead of rows? The presentation of my data is different in that each tab has data that needs to be presented in columns horizontally across one sheet rather than being appended as additional rows. I have total of 488 tabs relating to 488 sites so I need to present 488 columns in one worksheet. Can I achieve that with this query or can you recommend another? Thank you.
Thank you for this video. I don't think the power query would be able to refresh the data if another worksheet was added, say for Sweden but VBA could would work, correct?
Absolutely correct. VBA is more than capable of that. Power Query is also capable, but not the approach shown in this video. This performs it on those specific sheets.
@@Computergaga do you have a y vid that shows power query for when new sheets are added, I plan to use method as a master sheet for 20 sheets in one workbook that I have, each sheet represents a month/year and each sheet has a running balance, if I were to consolidate all those sheet into a master sheet using this method it could mean I could make up a another sheet that shows a balance by always retrieving the last numbers on a certain row where the running balance displays in the cell row. Only issue I see is when I need to add a new sheet for the new month/year. Would appreciate some help with this.
Hi Allan, How to append the a new sheet to already appended table. suppose In this case if I need to add a new sheet say Germany to the all-countries table which was already created by appending the 4 country sheets. I want know id it possible to do so, because each month I am getting data and want to append those files into the master table. Thank you
Sure, you can append a table to the already appended table using the same technique. Or if it is just changed data. You can replace the data in one of the tables and refresh the query.
I wasted almost 3 hours and finally found your video. It is simply awesome. Thank you, you made my day..:)
And you have made mine. Thank you Kratika.
@@Computergaga Flirting continues 😁😂
Also check out excellisfun RUclips channel. I reckon its one of the best
Love the guys who make tutorials straight to the point like yours.
I watched for 4 min and got what I needed Thanks man big time help.
You're welcome.
Brilliant mate. I was on the right path, but getting stuck, and this clarified exactly what I needed.
I'm going to do this first in excel, letting the business areas update their own data in locked-down sheets, then load the single appended file to Power BI for an extremely lightweight and quick report.
Thank you for this video . Straight to the point and very easy to understand.
Thank you!!! I return to this video year after year when setting up my yearly budget. So appreciate it!
3:44 Directions Start
You're so welcome! I am glad that it helps.
This was one of the most useful excel videos I have ever seen in my 8 years as a finance professional! Thank you!
Great to hear. Thank you.
This is exactly what i needed. It takes me 2 hours to consolidate sheets on daily basis. Thank You so much. This is so easy and time saving.
Brilliant! Happy to be able to help.
Right!!!!! I went through so many videos on Power Pivots, and then I find this one, in a couple hours, I get to build a beautiful Power Pivot Table. Thank you so much !!!
Glad I could help Iscia.
Allan, believe me when I see that my eyes nearly popped out of my head at 9:20 !! This is excellent info and exactly what I needed to combine two sheets containing future and historical timesheets for my team.
Awesome! Thank you, Charles.
This was great! After watching many other videos that just confused me, I was finally able to combine multiple excel sheets from your instructions. Some of my data across sheets were redundant so I thought that after appending them (combining them together) I'd have to go through and manually remove duplicates. To my surprise, either there weren't any duplicates to start (rare) with OR this process removed the duplicates, saving me from a lot of tedious work. Superb and many thanks!
You're very welcome! Happy to help, LaVera.
Thank you. Really easy to listen to. I struggle with my attention but your style and voice is engaging enough for me to take this information in. Thanks!!
Great to hear. Thank you very much for your comments.
Thank you. I learned a lot from this. From new raw data that I need to amend until I get what I want from huge multiple of worksheets. Combined and pivot has been made my life easier.. Head up, buddy!!!!
Awesome! Thank you, Roslan.
I spent about 2 hours trying to figure out how to merge multiple tables, thank you soooooooooooo much!
You're very welcome 👍
Hi Allan, thank you: well explained. One tip: add a new column to the queries: for exmaple: "France" , in this way you can later analyze per country. As to the question of Salam Miah: you can do this in regular Pivot: add the country in page filter and then you can make a report where all countries are displayed per sheet.
Thanks Bart.
So great, i've been trying to this sheets appending for weeks.... this tip will help me a lot a lot. thanks
You're very welcome. Thank you.
what a godsend..been wracking brains how to achieve this. This will be fantastic for our work with multiple users workbooks. Massive thanks
My pleasure.
This is very informational. Your teaching skill is phenomenal and I love your accent!
Wow, thank you 😊
You BEAUTY. Iv been trying to find a method of combining a credit card and debit card tables/worksheets to track transactions for specific categories and sub categories...Finally.
Great! Happy to help.
This video should be kept in archives even after humanity ends. That's how much helpful it is !!
😂 Thanks, Rahul.
Thanks very much, you are a hero, video is simple, briefly and clear.
You're very welcome! Thank you for your comments.
THANK YOOOOOOOOU 🖤 anyone using keynotes in Revit will understand how important and helpful this video is
My pleasure. Thank you 👍
Thanks for solution that I was searching for these days.
You're welcome. Happy to help.
THANK YOU VERY MUCH! THIS WAS EXACTLY WHAT I NEEDED TO DO!!!
You're welcome.
Excellent. Thank you. The only useful video I found here on the issue
Thank you Mudasir.
Excellent teacher.... Love you..... And thanks a lot
Brilliant! Exactly what I was looking for. Thank you.
Glad it helped, Mike.
Great Knowledge, Thank u so much.
You're welcome. Thank you.
Thank you very much, i have been looking for this for a while, you helped alot.
Awesome! You're very welcome.
Thank you. You saved my life. Many, many thanks
Obrigado. Salvaste a minha vida. Muito, muito obrigado
Você é muito bem-vindo. Obrigado pelos comentários.
Thank you for posting this. It solved an issue I was having and I am grateful indeed. Happy, Safe, and Prosperous New Year Sir.
You're welcome. Thank you very much.
excellent exactly what I where looking for!
Awesome! Happy to help.
Thank you Alan. It's been very helpful. Greetings from France.
You're very welcome Anne. Great to hear. I just uploaded a new video about appending data from multiple worksheets - ruclips.net/video/_uQDxzLPNbo/видео.html
Thank you! Thank you! Thank you! Worked like a charm!
Great to hear. Thanks Carlos 👍
Well narrated! Incredibly helpful.
Awesome! Thank you very much Siri.
Great example! my version of Excel exactly - thanks
Thank you, Michael.
Thank u Sir
Now i am totally satisfied with this👍👍👍
Excellent! My pleasure Fuad.
Thank you for this video helped s0lve a problem i had been battling with for days
Awesome!! Happy I was able to help.
Subscribed and liked. Thank you so much for a video I needed for work!
My pleasure. Thank you.
I can't thank you enought for this tutorial.
You're very welcome!
That is stunning. Thank you Alan. A truly useful function. 👍
🌟 🌟 🌟 🌟 🌟
Thank you Salim.
Thanks so much! It worked hot-doggie!!!!
😊😂 awesome!!
Excellent instruction, Thank you!
Thank you very much Donna.
im about to cry, thanks sooooooooooooooooooooooooooooo much
You're very welcome Sayed.
Exactly what I was looking for! Thx a lot!
Excellent. My pleasure Chris.
Alan - another clear and most helpful video! Question though: wouldn't it be to your advantage (in terms of using a pivot table for analysis) to include the country name (UK, France, Spain, Italy) as an additional column for each individual table and then do the steps for an Append Query? I ask because once you have set up your worksheet that has ALL tables combined and then proceed to create a pivot table, you don't have a way to differentiate between the four countries....hopefully that makes sense! Anyway, I follow your RUclips channel regularly and find your help invaluable. Thank you!!
U are a life saver ❤️
😊
So good! You talk slowly which is awesome!
Thank you Izabel.
Hello, this is perfect, exactly what I was looking for. I am switching over from using Google Sheets and I am struggling a little with some of these minor things like combining sheets into 1 which is very simple in Google. I am wondering if there is a way to have your combined worksheet Refresh automatically or would i need to do a VBA code to do that?
You would need the VBA I think to refresh them automatically Megan.
Thanks for the useful video, however in my case the connection only tables does not read all the rows from my actual worksheets. if totaling all the rows in my worksheets are 100, then the appended worksheet shows me only 20 rows. How to resolve this?
Nice! Thanks
You're welcome. Thank you.
Still relevant over a year later! Thank you!!
Excellent!
Great video. Thank you. I have a very large excel file that I would like to append small amounts of data to without opening the large file. I process monthly data and then would like to save it to a file that contains all data. Up to now, I open the large file and manipulate it, which is time consuming. Is there a way to do that?
This was incredibly helpful! I am having a problem with long account numbers turning into scientific notation (E+) though. I went to the original source data and added an apostrophe before the account numbers but the account numbers are still showing as E+ numbers. All cells are formatted as text. Any ideas for how to fix this?
This was super helpful! Quick question: does this work when I send the file to other users?
Sure. This example works as the data is within the same sheet. If the sheets were from an external workbook, then we would need to consider the file path and access when sharing.
Thank you.
Thank you, Kamana.
This is exactly the same way you do it in PBI!! Thanks.
You're welcome Larah, thank you.
I know i am two years late, but you have saved my life - thank you!!
Never too late to save a life. Happy to help.
Great video - been scared to use PowerQuery. Can you please do a video on combining workbooks with PowerQuery? Thank you.
Thank you, Debbie. Don't be scared. Power Query is fantastic.
I have a couple of videos on your suggestion. Here is one - ruclips.net/video/9ljqozOVEWY/видео.html
@@Computergaga Thank you so much. I will take a look :)
Very useful Trick!
Thanks Learn Excel.
Excelent explanation!. Really usefull.
Thank you Miguel.
This was incredibly helpful! Do you have any videos on how to use this new master table to add new data to all the source tables? I'd like to use this consolidated view to add in quote and delivery information without having to go to each table individually. Thanks :)
Sure. You would have other queries/tables reference this master table (lookup referencing queries in Power Query). And these queries can then be filtered to only show what you want.
There is also the new FILTER function that can help with this in Excel 365 - ruclips.net/video/kdl3mNEyIRE/видео.html
Hi ! Great video, I am wondering what you would advise in terms of extra steps to perform, should each tabs contains different columns contents while the end goal is still to combine the specific columns data from the different tabs (in my case, i have for example 20 stock on hand reports from various locations, that have various different columns) as i am only interested in getting into the master tab: the location the sku is stored, the quantity, and of course the sku code). Thanks!!
Fascinating!
Thanks M. Raed Al Lulu.
Thank you so much for your videos, they have helped me immensely.
Question regarding Append in Power Query. I have a template where I utilize a dropdown list in several columns. I noticed when I change the worksheet to a table, that option disappears. Is that correct? Is there a way to keep the drop down options?
Thank you in advance for your help!
You're very welcome, Kathleen. The dropdown options should remain. I believe you are referring to Data Validation drop downs and they should remain.
This is a great video thank you! I am curious if anyone know if there is a way to set this up so I can edit the information on the combined table and have it make those changes to the original tables? thanks so much!!
Thank you. You would want to reverse this process if you need it the other way around. You can create multiple tables/queries that reference the big query. Then filter each one so that it only shows the info you want. Any changes to the big one, when refreshed would then update the other queries.
This is awesome, many thanks!
You're very welcome Joshua.
Subscribed
Thanks a lot. It is working great!.
Question. How can i share this file with others. I tried copying the file into the others computers, but got an error refreshing data. Am I missing somthing?
Thanks in advance
Thank you. You can copy the file just fine. The issue with refreshing is probably an issue with the filepath that gets coded into the Source step.
The recipients of your file would need to edit this to their filepath to the files.
Hi Good explaination. Can u please share a video which shows how to append from different sheets of diffrent worksheets from different workbooks not from different worksheets from same work book.. imagine in your example if france sales data is in combine -sheets.xlsx and spain sales data is in Spainasales_combinesheets-sheets.xlsx
Hello, do you have the files for this video? The tutorial has been very helpful, thanks!
Great to hear Flor. I do not have the files, sorry. You ca use any small workbook to practise though.
Great videos! Is there a way to find/search sequential numbers in one column?
Thank you, Nemanja. I don't fully understand your question. I cannot picture the scenario.
@@Computergaga For example, you have 1000 numbers in one column and you want to analyze them to find some patterns, such as consecutive numbers, duplicated numbers, etc.
Thank you for this nice video , you have described how to combine files under each other having same column headers.
But how can i combine files having same rows , beside each other ??
Thank you, Bola. You will want a Merge Query instead of the Append Query for this. You need a column in each table to match the rows.
Computergaga Do you have a video for this ? I mean how to merge sheets without doing data specially if they are not even
Sure, I have a Merge queries video here - ruclips.net/video/qCxVMP5sqtY/видео.html
@@Computergaga Really i would like to thank you so much :)
But let me ask how can i merge 10 files with uneven structures , can i send you an email ?
No problem.
I have received and replied to your email.
Many thanks
You're very welcome.
Extremely useful! Thanks :-)
You're welcome Alex. Thank you for watching.
Thank you for your video! I learned something again. My next problem, I have 60 sheets, very time consuming to convert them all to table and transform the data. Any help on this? Thanks.
Same issue for me.Please let me know if you find the solution
Thank u sir very interesting ,
You're welcome Suresh.
Hi Allan, this was really great! do you have any video with explanation how we could add new sheet to existing query? i am struggling right now with it and any support would be more than welcome. :-)
Thanks, Milan. You can edit an existing Append query to add a sheet. Open the PQ Editor and select the query. In the Applied Steps on the right, click the gear icon next to the Append step to edit it and add the additional sheets to append. Hope that helps.
Thank you
You're welcome Shubham.
Hi Alan, Thank You so much, very very useful video.
You're very welcome Akash. Thank you.
you just saved my life!! ahhh thank you so so much!
You're very welcome. Thank you Daysi.
Superb
Is it possible to do same for multiple workbooks in a folder those are having multiple sheets. If new data added in existing workbooks or new more workbooks added, will it automatically update.
Thank you. I have this video on importing multiple files from a folder - ruclips.net/video/9ljqozOVEWY/видео.html
Great tip Alan, many thanksCheersMohideen
Cheers Mohideen.
Very useful
Thank you Waris.
How to do the opposite of what you did here? Please show how to create different tab by country from "all country" tab. Thanks
So today i learned something new about the Append Query feature. At first, i thought this was beneficial because it connects tables together. However, now i see it does a little bit more than just that.
It creates value in the sense that once we have an append query set up, we could use it to save time. We could save time with it by removing the reoccuring step of having to rearrange a table due to differences in how columns are aligned.
Again, this shows how using power query could be thought of as a more straight forward or user friendly approach to lookup. With a lookup function, i could have it extract data from specific columns. The issue with this is that if i am using column numbers as my return array, there's a very high risk of getting the wrong info returned to me in the event that the column number changes. however, when i use named labels, could i reduce the liklihood of incorrect data. It seems like the append query feature reduces that need to constantly have to rearrange the columns without having to learn the complex lookup functions.
This video was very helpful, thank you so much! one further question - is there a way to also add a column with the name of the worksheet or Table that the data are pulled from in the Append/combined version? Eg, an extra column that would show the row was from France or Spain, etc.
You're very welcome Heather. You might like this technique more as it includes the names column - ruclips.net/video/_uQDxzLPNbo/видео.html
same method can be applied to combining multiple datasource text or csv files together using connections.
Absolutely. Once they are connected and we have them as a query, anything can be appended.
Thanks, Harjit.
u r great
Thank you, Wesam 😊
Subject is very good, let me test and come back to you, if successful and I expect, will save time especially when you did this with tenths of sheets hugely data 🙏
Yes it is very helpful. Can speed up regular processes.
Thanks, how to add the country column in the appended list from the table names, so that it will be easy to see which sales is related to which country.
This is great video.Is it possible to download these worksheets for practice.
Thank you. I don't have this file anymore, but you can just create a few sheets for practise. They don't have to be large, just a few rows to get the techniques down.
Thank you it helped alot
Fantastic! Great to hear.
Great tutorial, where Can i find the data ?
Thank you, Pierre.
The data is not provided for this video. I just did a search on my system and looks like I've removed the file. But you can practise this with any sheets. Any dummy data would work for practise.
Thank you! This is very useful. I have a question please. Is it possible to append data coming from other tabs into columns instead of rows? The presentation of my data is different in that each tab has data that needs to be presented in columns horizontally across one sheet rather than being appended as additional rows. I have total of 488 tabs relating to 488 sites so I need to present 488 columns in one worksheet. Can I achieve that with this query or can you recommend another? Thank you.
Yes, instead of an Append Query, you want a Merge Query.
Mate,...do each of the tables have to be exactly in the same format ?? Mine are slightly different, and have 14 tables to combine. CHEERS !
Yes, the headers need to match. If they don't they can be adjusted prior to appending.
Thanks awesome
Thank you Syed.
Thank you for this video. I don't think the power query would be able to refresh the data if another worksheet was added, say for Sweden but VBA could would work, correct?
Absolutely correct. VBA is more than capable of that.
Power Query is also capable, but not the approach shown in this video. This performs it on those specific sheets.
@@Computergaga do you have a y vid that shows power query for when new sheets are added, I plan to use method as a master sheet for 20 sheets in one workbook that I have, each sheet represents a month/year and each sheet has a running balance, if I were to consolidate all those sheet into a master sheet using this method it could mean I could make up a another sheet that shows a balance by always retrieving the last numbers on a certain row where the running balance displays in the cell row.
Only issue I see is when I need to add a new sheet for the new month/year.
Would appreciate some help with this.
Thanks buddy,good explanation but your video is blurred
Thank you, Livingstone.
So, in older Excel with no Power Query, it won't be possible to do this, right?
Only with a macro. Power Query cam out in 2013 as an add-in. 2016 in Excel.
@@Computergaga which means, you'd have to manually copy and paste everything, eh?
Sure, unless you use a macro. Or upgrade to Microsoft 365 😀
@@Computergaga goddamn it ) thx for the answer.
Hi Allan, How to append the a new sheet to already appended table. suppose In this case if I need to add a new sheet say Germany to the all-countries table which was already created by appending the 4 country sheets. I want know id it possible to do so, because each month I am getting data and want to append those files into the master table. Thank you
Sure, you can append a table to the already appended table using the same technique.
Or if it is just changed data. You can replace the data in one of the tables and refresh the query.