Merging of 5 Excel workbook into 1

%3CLINGO-SUB%20id%3D%22lingo-sub-2356596%22%20slang%3D%22en-US%22%3EMerging%20of%205%20Excel%20workbook%20into%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356596%22%20slang%3D%22en-US%22%3EGood%20night%2C%20I%20need%20some%20assistance%20with%20merging%20five%20excel%20workbooks%20into%20one%20worksheet%20to%20be%20able%20to%20have%20each%20branch%20and%20their%20stock%20items%20matched%20and%20tallied%20to%20obtain%20final%20closing%20stock%20of%20all%205%20branches.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2356596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2356625%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20of%205%20Excel%20workbook%20into%201%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2356625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054351%22%20target%3D%22_blank%22%3E%40Sabita%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20for%20you%20to%20post%20copies%20of%20those%20workbooks%2C%20or%20is%20the%20information%20in%20them%20considered%20confidential%3F%3C%2FP%3E%3CP%3EIt's%20hard%20to%20give%20assistance%20without%20a%20far%20more%20complete%20understanding%20of%20what%20you%20have%2C%20how%20the%20workbooks%20are%20laid%20out%20(are%20they%20consistent%20across%20all%20five%20branches%3F)%2C%20and%20exactly%20what%20you%20mean%20by%20%22matched%20and%20tallied%22%20...%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Good night, I need some assistance with merging five excel workbooks into one worksheet to be able to have each branch and their stock items matched and tallied to obtain final closing stock of all 5 branches.
2 Replies

@Sabita 

 

Is it possible for you to post copies of those workbooks, or is the information in them considered confidential?

It's hard to give assistance without a far more complete understanding of what you have, how the workbooks are laid out (are they consistent across all five branches?), and exactly what you mean by "matched and tallied" ...

@Sabita Assuming that the file structure / layout for all five workbooks is the same for all five branches, you could put them in one folder and connect to the all files in that folder with Power Query. If you are not familiar with Power Query (PQ), it may be a bit overwhelming in the beginning, but it's worth looking into. The attached link is a good introduction to PQ in general. Chapter 9 deals with connecting to files in a folder, specifically.

https://exceloffthegrid.com/power-query-introduction/