I see no one has replied yet to my question although there have been 50+ views. I have been looking at some other threads related to slow Power Query...
Hi Hans, Thank you for your quick reply - and I'm sorry for my tardy response. I wasn't sure exactly how to use the ListObject object in VBA so I ...
Hi Catalin, I will definitely check this out. Thanks for the link. Regards, Scotty
Hi Velouria, That worked! How succinct and functional! As you can probably tell, I'm a novice Excel VBA programmer. So, I was (and still) unawar...
Hi Catalin, Thank you. This was very helpful. Sorry for the late reply. Scotty81
Riny, Thanks! I see that your solution certainly worked! I'll modify it for my specific file. Not sure if there was a subtle difference, but I'm...
Hi Riny, I didn't attach a file, but what I mean is let's say I have some data about projects. The raw data might contain columns on cost, due dat...
Hi Mynda, Thanks so much for providing an example file with the revised dimension and fact tables. Your response about the table structure made se...