Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

If at all possible I'd like to do this without VBA, and I'd like it to work cross-platform in Win Office as well as Mac Office. My cumbersome method currently does both, but it's . . . cumbersome. If ...

Does VBA for Excel not allow nested while loops? I don't write macros all that often but whenever I do, I nest a while loop (because I forgot that it didn't work last time), it errors out and I end up ...