On Mon, 12 Oct 2009 21:50:01 -0700, Calgarychris
wrote:

Ron,

Thanks very much, this code (whatever it's doing!) works beautifully. I
amended the MaxNumTitles to 14 and added a few titles to the list, but other
than that it produces exactly what I was looking for (any surprise is because
you were able to follow my convoluted question, not the fact that your code
works!). My co-worker tells me that although there are now multiple banks
listed after each title, that we can split that data apart...we'll see :)

Thank you again!
Chris

I'm glad it's working for you.

Thanks for the feedback.

The code could certainly be modified to split the individual banks (and even
the percentages after), but one would need to know more about the set up of the
input and desired output in order to do that effectively.

Perhaps you might even want to have a separate worksheet for each item.

In any event, I was glad to help. It was an interesting exercise.
--ron