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

Hi
please post a sample sheet showing what you have and the expected result ( no pic please)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post