Hi,

This is enormously difficult. I kept the link to a solution posted by Harlan
Grove which in my opinion FWIW is an awesome piece of coding. Note in the
comments at the top of the code you need to set the 2 references this is done
in VB editor using TOOLS|References.

http://www.microsoft.com/office/comm...664&sloc=en-us

Mike

"Nikki0195" wrote:

I have a LARGE spreadsheet of items that I am trying to reconcile for an
entire month range. The issue that I am having - the bank statement may show
one amount ($1,000), where the spreadsheet may have 4 random amounts that
equal $1,000. I need to be able to find the items that equal a specified
number without having to manually add up several amounts and hope for a
match. Any suggestions? I have tried Conditional Formatting, Conditional
Sum, and the Solver add-in. None of these will give me what I need -
considering that I have about 400 items in a month.

Thank you all so much for taking the time to read this!