Forum

Thanks Mynda. I will try that. Glad to see Microsoft are looking at a solution.

Hi Catalin, Thanks for your input. I have worked out where I was going wrong. When I was combining the files it asks you to select the object to be...

Hi Catalin, There are three example files attached to my original post. There is also a file called Summary which indicates what I am hoping to get...

Hi Catalin, Thanks for the response. What I can't work out is how to include all of the sheets from all of the files. Bax

Hi, Here is the Microsoft page relating to this topic: As you can see nothing much is happening. Bax

Hi Mynda, Slap on the wrist accepted regarding breaking the rules. However in my defense in the full file there is a lot of VBA and formulas that u...

Hi Mynda, That works perfectly. Sometimes when using Power Query I think that everything has to be done there and overlook the usual Excel finction...

Thanks Mynda that solution works fine.