Comparing dates to find data

**zbor** · 03-24-2009, 11:09 AM

See if you can use this... I did it for some other user today, but if this is good start we can adjust it for your particular problem...

Attachment 39621

**sentinela** · 03-24-2009, 11:30 AM

zbor,

Thank you very much
That helps some...
This is exactly I am trying to do...

Book1
John Smith - $245.00 - 2/10/09
Bill Davies - $650.00 - 2/20/09

On Book2 when I
John Smith - $245.00 - 2/10/09
Bill Davies - $650.00 - 2/20/09
Jane Doe - $100.00 - 3/5/09

Now on Sheet2 I am trying to find out the last day that I charged interest on these people. Some of them came in and some others went out. So this is what I need to do...

Go to Book1 find the names the last date that they were charged and then. Go to Book2 and find if there are any new people, and then on Sheet2 come out with the results.

Thanks!