Apr 26 2022 11:25 AM
Hi,
I want to create a unique report using different excel files, how can I do that
Many thanks
Apr 26 2022 12:29 PM
Get & Transform aka Power Query is probably your friend assuming you run a recent version of Excel on Windows
Apr 27 2022 09:05 AM
@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.