Forum Discussion
Macro to Extract Data from 500 blocks of Information. Help!
Thank you so much, Wyn! Genius! Everything worked like a charm! I really appreciate the time you took to fix the file and then communicate to me how to then do it myself. You sure saved me a ton of time and effort trying to figure this all out on my own. Really appreciate it!
No problem, Power Query is definitely worth learning about.
If you do a lot of this sort of thing then I can't urge you strongly enough to attend a course on it.
Also the best book on the topic is this M is for Data Monkey
Good luck
Thanks again, Wyn. I'm a retired instructor who helps friends out when they get stuck using Excel. In this case, our church needed the help and called me. I will go over there today to show them what you did. You are saving HOURS of time for someone and she really will appreciate it. Thanks for the book recommendation as well! I can pass this along to several people I know.
Wyn, I was over at our church today and just as I was ready to watch their secretary do her "happy dance", I saw that she had Office 2016 loaded on their computer and "Get & Transform" was already on the Excel ribbon. Well, of course, all of your instructions (as perfect as they were on MY computer (2013), her ribbon doesn't look anything like mine. So now she has a Data tab and only a few options underneath that. Is it possible for you to update your notes for a 2016 environment? I tried many things and didn't get close to successful. ugh! When you have time. Thanks so much once again!
- Hi Sue
Show Pane is now Show Queries
Data Source Settings is now at the bottom of the list after clicking New Query.
Other things should be the same