Hi,

I have this problem, can anyone recommend anything that will make m
life easier...

I have two lists of numbers (lets call them list A and list B) and
want to run a macro that will match the two up nicely!

The totals of the two lists can be equal or they may not be equall - i
differs each time!

A number in list A may match a number in list B directly.
Alternatively the sum of some of the numbers in list A may equal on
number in list B (and vice versa). Occasionally the sum of severa
numbers in list A may match a sum of numbers in list B.
Finally some numbers will have no match in the other list.

Is there a macro or other method within excel that will identify thes
matches, potential matches etc... or is this something beyond it
(albeit impressive) capabilities?

As you can imagine i have been working on this for quite some time
the only result being that my head, much like my macros, no longe
work!

Many thank

--
Message posted from http://www.ExcelForum.com