Loading Sheet of closed workbook to "Thisworkbook"

[ImranBhatti]

Hi,

I have multiple files in a folder with completely same layout (same number of sheets, same sheet names etc).

What I need is to load complete sheet into "Thisworkbook to see what has been done in that file?.

Requirement: I need to do this using Power Query.



Note: My files don't have Excel Table.
Thanks in advance

Imran Bhatti

[Olly]

Without seeing your source structure...

Try something like this:

Please Login or Register  to view this content.