Forum Discussion
Macro to Extract Data from 500 blocks of Information. Help!
I have attached a file with just two blocks of information that was downloaded from another program. There are over 500 blocks in total. I need to first Replace All occurrences of "Totals: $" with ...
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!