Combine Excel Sheets the EASY Way with VSTACK

[@koidamiracle8929]

Your teachings are always good with better explanation

[@TeachersTech]

Glad you think so!

[@iamdrdeath]

I like this function. I've utilized the Filter function to return the stacks after watching this works a treat and much easier!!! Thanks

[@marjoriestevens3668]

Just what I needed. So easy to follow. Thank you 😊

[@TeachersTech]

Glad it was helpful!

[@IvanCortinas_ES]

Excellent explanation. Thank you!

[@TeachersTech]

You’re welcome!

[@JB_inks]

Ctrl-Shit home and end also go to the first and last cells on a sheet with data

[@רועיחרוב]

Thank you very much. Do I have a way to preserve the original formatting such as colors or bolds?

[@mehdimirj]

Thanks for the tip, but I have a question: how can I use this formula in combination with INDIRECT due to variable sheet names?

[@ProunoundGaming]

Hello! Do you have a video that does the basically opposite of this. my son has started a lego business where he buys boxes of Lego and builds the sets that are in them, sells them when complete. rinse and repeat basically. he has expanded it to a point now where we cant keep track of it properly. For Example if I have a main sheet for 'products' and on that sheet I can have a column for; Set Name, Set Number Code, Location, Set Status etc. Now having 'Set status' as a drop down menu i can have a list of option, say; Incomplete, parts ordered , Completed, Listed, Needs Shipping, Shipped, Sold. and all of these drop downs be a separate sheet. so if i need to buy parts for sets, i can go to the incomplete sheet, see what sets need Parts, order those parts and when they have arrived and the sets have been completed we can just change the status on the main sheet to Complete, and that will update the the file so it is removed from incomplete and added to complete. i hope this makes sense

[@tammymarik]

Is there a way to do this with out getting duplicates ? I'm looking for something to import new data only. Like fill in data where its missing, but not re-add the data that is already there.... i hope this makes sense.

[@joshuvachinta4177]

I followed the same instruction but it is showing #spill what should i do now Please guide

[@StefanoVerugi]

I understand this is just an example, maybe in real life those tables are better used as named type range so you can dynamically stack them without problem in case they expand vertically.. right? thanks for the video

[@TeachersTech]

My preferred method for this would be power query to bring all the sheets together and clean the data. Easy to refresh for new data.

[@StefanoVerugi]

@@TeachersTech yes, it's the right way to go, totally agree 👍 But, for large datasets, maybe python pandas would be more efficient?

[@jeffreyscottfishman]

Could you please send the link of your video on basic excel for beginners if you have one? I'm just not good at this. I just need to know the basics on starting out for the first time. Thanks

[@TeachersTech]

Here you go! kzbin.info/www/bejne/oWK5ho17i9p3gJo

[@LiamBriggs18]

kzbin.info/www/bejne/p4e3nZyldtaIrJosi=dk6kRvheFM1UUnm- This one's his 3 hour masterclass, it's probably more comprehensive than you're looking for, but it's a great reference for you to jump in and out of

[@jeffreyscottfishman]

Thank you!

[@maxbrown9901]

Nope i don't have the microsoft 360 subscription..only have the regular desktop version so vstack does not work for me.

[@nikosmakrymanolakis3042]

I'd do it with named tables, and then just VSTACK(Table1;Table2;...). And when lines are added/deleted on original source tables, VSTACK output will adjusted automatically. Why bother with lines?

[@TeachersTech]

Yes, using spill functions like VSTACK, tables are a great way to have it dynamically adjust.