Originally Posted by BobBridges

I would love for you to understand the relation between the VBA code and what comes out on the Print out worksheet; and if you want, we can talk about that as a side question. If you've taken a VBA class before, then you should be able to get it all to come back. Let me know if you want to do that. But if I remember excelledsoftware's solution, you should be able to expand the worksheet without having to change the macro he wrote for you. All his program did was write out a list of contact persons and dollar figures in Y:Z starting at row 8. Getting it into a double-column listing is all the work of formulae in A832. I believe you can expand on that without having to know anything more about the VBA program than that it writes its output to Y8:Zn, where n = "as far down as necessary".

Given that, take a look at the formulae in A832. In particular, note that the formulae in A8:A32 identical to B8:B32, but that A8:B32 are different from C832. How are they different? What (exactly) do they do? I think if you look at the difference, and figure out what the two different formulae mean, you'll have a broad hint about how to proceed from there.

I'm not abandoning you; but start there, and if you don't get it yet, come back and ask more questions.