Contrary to popular belief, working on files online can be trouble-free. Sure, some file formats might seem too hard with which to work. But if you get the right solution, like DocHub, it's easy to modify any document with minimum effort. DocHub is your go-to tool for tasks as simple as the ability to Consolidate Feature Article For Free a single file or something as intimidating as dealing with a massive pile of complex paperwork.
When it comes to a solution for online file editing, there are many solutions available. Yet, not all of them are robust enough to accommodate the needs of individuals requiring minimum editing functionality or small businesses that look for more extensive set of features that allow them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing paperwork online more simplified and easier. Sign up for DocHub now!
welcome to XL magic number 814 hey Ive done it XL magic trick number 90 on consolidation all I want to do this video like socia all the tricks i know in consolidation but theres one trick i left out and thats how to consolidate from a different workbook so up here our workbook name is total workbook and im going to use the keyboard shortcut ctrl tab i have a lot of windows open but i have three workbooks and control tab will toggle control tab control tab just between the XL work bus so heres the total control tab here is consult the data for from workbook to heres the data for workbook one and my goal is to take this data and this data and consolidate it now notice it says product one product to january through october but this one has product one product three and only january through june the consolidation figure feature will know to have all the months and all three pop products alright so im going to start in his control tab start here and the trick to consolidation again