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