Quote Originally Posted by twmills View Post
I tried the macro and it only returned the first two account numbers (65436453653 and 6543654356) and just the first DLR A/C # (Q3Y401538).
That's how left it; I'd removed the results so you could could see it being updated with the current sample data you provided. You did click the button (having enabled macros, of course) and waited a second or two (Power Query often takes a little longer at the first update)? I just checked it again by downloading the attachment from this site and it works fine, bringing in all 6 pairs of numbers.

So let's have a peep at this source file, it should be easier to grab the data you need directly from the file without having to bring it into Excel first. It makes handling new versions of the file easier too.