Forum Discussion
JoeCavasin
Aug 28, 2021Brass Contributor
VBA Nested Looping Structure
Need help as i'm getting up to speed on VBA for Excel. Took most of Leila Gharani's VBA course and found it incredibly helpful but of course lots to learn before I have enough knowledge base locked ...
JoeCavasin
Aug 30, 2021Brass Contributor
never yet encountered "Get & Transform" /Power Query. From the online help documentation, "Get" is used to import from multiple sources. My goal is to send to multiple sources from a single source. Unless I'm missing something, it doesn't appear this would be a solution for me? My users are not tech savvy, and my goal is to do a single action to send the info out, as opposed to multiple actions - one from within each receiving workbook - as the get function might appear to work in the suggestion? That's a lot of books for a supervisor to open and then manually kick off a get function - doesn't seem much faster than a copy/paste. Again if i'm misisng something in get/transform please let me know - i'm game for a simple, single click solution with repeatable, reliable (relatively error-proofed) outcomes.
JKPieterse
Aug 30, 2021Silver Contributor
In your case, you would create a data connection in each client file that pulls in the required data, so instead of pushing data, you're pulling data.
- JoeCavasinAug 30, 2021Brass Contributorand i can initiate all of those pulls by a single action, not one action per client file?
- JKPieterseAug 30, 2021Silver ContributorYou can set the connections to automatically refresh when e.g. the file is opened or at set intervals