Hi,

I'm trying to keep on top of payments made to me and was hoping someone could help me with the following...

I have two sheets in my workbook. One contains customer name, project number and some other values. The other one contains the payments and payment info. Both sheets have the project number in common (or at least should).

What I'm trying to do is the following:
Priority 1: In a sheet (could be the first one), I'd like to be able to expand a client, then have a list of their projects and how much has been paid up until now. If I expand the project line, I want to see the separate payments made.

Priority 2: If payments doesn't have valid project number (no matching lines from sheet 1) or it's missing, I would like them sorted in some way making it easy to see and manually fix. (not important - should never happen)

If someone could help me with this I would be extremely grateful!

Cheers,

Lars