Is there anything else to identify the entries-such as a received date on the cheques and
a deposit date on the deposits?
If, for example, the cheques had a received date you could group them by date and compare
the total to the deposit for that date or, if the deposits are made on infrequent dates,
accumulate the cheques within a deposit date range.

Failing having a date for a point of reference, i.e. having amounts only, it would be a
difficult task given that any number of cheque combinations could equal a deposit total..

--
Regards;
Rob
------------------------------------------------------------------------
"Frank R via OfficeKB.com" <u11209@uwe> wrote in message news:589ba7f2a3c17@uwe...
> I hope I'm able to explain this properly. I'm trying to match lists of up to
> a thousand checks with lists of maybe a hundred or more deposits. The number
> of checks per deposit can range between one and dozen or more. I've been able
> to make a spreadsheet using formulas to find if there are only two checks for
> each deposit with this formula: =IF(($A$1+A2) = B1, "Match", False) then
> dragging it down and changing it as necessary going across. The list of
> checks is in column A with one deposit at a time in B1. Obviously it requires
> most of the worksheet. My question has two parts; I have to use find to find
> the matches, then look at the formula to see what cells it refers to and go
> from there. Is there a way to write code to highlight the matching cells?
> Maybe by bringing the cell references up in a dialogue box? Something like
> "match found in cells A34 & A78."
>
> Also, doing what I did above looking for 3 or more checks is HUGE. Is there a
> way using VBA to find these? I've been trying to learn VBA with mixed results,
> and I appreciate any help.
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...mming/200512/1