Forum Discussion
Macro to Extract Data from 500 blocks of Information. Help!
Hi Sue
You'd be best off using Power Query (Get & Transform) if you can for this.
What version (Excel 2016, 2013, 2010) of Excel do you have?
If 2010 or 2013 then download Power Query https://www.microsoft.com/en-au/download/details.aspx?id=39379
I've attached a solution using this, and can talk you through how to use it
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!