Hello, thank you in advance for any assistance. I'm trying to put together a
reconciler that compares what I know to what is coming into me from an
outside source. I have some experience w/ VBA but none with arrays. I think
that an array is most likely the best way to do something like this.

On the sheet "Input" (where I put in what I know)

Product Qty Price Contract Qualifier #1 Qualifier #2
ID

I have:
*12 choices for products
*Any number for the Qty (possible if we bought, negative if we sold)
*Price is from .1 to 30001
*39 choices of contracts that vary each month (I have a reference in a
column on the "Main" sheet of the available contracts)
*Qualifier #1 is like a bar code #1000 to 30001
*Qualifier #2 has 3 choices A,B,&C
*ID is 1 of the 10 people responisble for the product transaction (I have a
reference in a column on the "Main" sheet of the available people)

The sheet "Account" shows the statement we receive that shows the
counterparty's recognition of the transaction. The two sides often don't
match and I'm trying to find a good way to hilite where it does not match.
The "Account" sheet is formated in the exact same way and order of columns as
the "Input" sheet.

So, I would like to compare our side to their side and output only where we
do not match.

I would like to criteria and output to look like this:

A is our side
B is their side

QtyA-QtyB
where ProductA = ProductB & PriceA = PriceB & ContractA = ContractB &
Qualifier#1A = Qualifier#1B & Qualifier#2A = Qualifier#2B

If QtyA-QtyB = 0 then
Show nothing

If QtyA-QtyB < 0 then
Show Qty Difference and list all transactions in that product, contract,
price, qualifier#1, & qualifier#2.


Please let me know if you need more information. Again, thank you for any
help in advance.