I'm working on a project where I need to extract data that comes in a relatively poor format. The data consists of stock and bond holdings for a particular client and I need to loop through the data and pull out the market value, percent assets, rating, etc from the information. In column A there is there is a repeated account name that occurs every 2-3 rows. I'm having trouble figuring out a loop that can recognize the account name and then offset and extract the other data. Also, different accounts have a different number of holdings so I'm planning on using a do until loop that will stop at the Total Portfolio line. Any ideas would be appreciated.

Thanks.