Merging 4 or more workbooks -

%3CLINGO-SUB%20id%3D%22lingo-sub-1602815%22%20slang%3D%22en-US%22%3EMerging%204%20or%20more%20workbooks%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1602815%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20sorry%20I'm%20a%20fairly%20basic%20excel%20user!%20I%20am%20trying%20to%20work%20out%20if%20I%20can%20merge%20data%20from%20separate%20work%20books%20to%20save%20me%20having%20to%20input%20the%20information%20time%20and%20time%20again.%26nbsp%3B%20I%20hope%20that%20makes%20sense!%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1602815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1603319%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%204%20or%20more%20workbooks%20-%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1603319%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F766401%22%20target%3D%22_blank%22%3E%40Leni13%3C%2FA%3E%26nbsp%3Bthere%20are%20many%20guides%20online.%3C%2FP%3E%3CP%3Eas%20an%20example%20this%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myexcelonline.com%2Fblog%2Fconsolidate-multiple-excel-workbooks-using-power-query%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myexcelonline.com%2Fblog%2Fconsolidate-multiple-excel-workbooks-using-power-query%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ealternatively%20you%20can%20google%3C%2FP%3E%3CP%3E'excel%20power%20query%20merge%20workbooks'%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi there, sorry I'm a fairly basic excel user! I am trying to work out if I can merge data from separate work books to save me having to input the information time and time again.  I hope that makes sense!

Cheers.

1 Reply

@Leni13 there are many guides online.

as an example this

 

https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/

 

alternatively you can google

'excel power query merge workbooks'