Excel report

%3CLINGO-SUB%20id%3D%22lingo-sub-3295530%22%20slang%3D%22en-US%22%3EExcel%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3295530%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20want%20to%20create%20a%20unique%20report%20using%20different%20excel%20files%2C%20how%20can%20I%20do%20that%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3295530%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3296776%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3296776%22%20slang%3D%22en-US%22%3EMany%20thanks%20i%C2%B4m%20going%20to%20try%20it%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3296654%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3296654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1374034%22%20target%3D%22_blank%22%3E%40josefina2215%3C%2FA%3E%26nbsp%3BIf%20you%20are%20not%20familiar%20with%20PQ%2C%20perhaps%20this%20is%20a%20good%20start%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThough%20it%20may%20a%20bit%20overwhelming%20in%20the%20beginning.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20particular%2C%20chapter%209%20deals%20with%20connecting%20to%20files%20in%20a%20folder.%20Perhaps%20it's%20something%20you%20can%20use.%20But%20you%20may%20need%20to%20clarify%20your%20intentions.%20Upload%20or%20share%20a%20file%20explaining%20what%20you%20want%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3296527%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3296527%22%20slang%3D%22en-US%22%3E%3CP%3Eok%20and%20how%20does%20it%20works%3F%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F75890%22%20target%3D%22_blank%22%3E%40L%20z.%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3295613%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3295613%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1374034%22%20target%3D%22_blank%22%3E%40josefina2215%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGet%20%26amp%3B%20Transform%20aka%20Power%20Query%20is%20probably%20your%20friend%20assuming%20you%20run%20a%20recent%20version%20of%20Excel%20on%20Windows%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I want to create a unique report using different excel files, how can I do that

Many thanks

 

4 Replies

Hi @josefina2215 

 

Get & Transform aka Power Query is probably your friend assuming you run a recent version of Excel on Windows

ok and how does it works?@L z. 

@josefina2215 If you are not familiar with PQ, perhaps this is a good start:

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

Though it may a bit overwhelming in the beginning. 

 

In particular, chapter 9 deals with connecting to files in a folder. Perhaps it's something you can use. But you may need to clarify your intentions. Upload or share a file explaining what you want to do.

 

Many thanks i´m going to try it