Forum Discussion
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 ...
I'd go for option 2. You'll see soon enough whether you need to redo the copy for each file or not 🙂
Can't you use Get & Transform to retrieve the data from that master workbook into each persons workbook rather than using VBA?
Can't you use Get & Transform to retrieve the data from that master workbook into each persons workbook rather than using VBA?
- 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.
- 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.
- and i can initiate all of those pulls by a single action, not one action per client file?
