HI Guys, i was wondering if some could help me with this one, i'm trying
to create an algorithm that will match between to lists and copy the
match data from list 2 into list 1.

Its for and order system, List 1 contains information of all orders
made, and the orders can have more than one order line, with each line
representing and item bought. List 2 comtains the Invoice data, but
this is where it gets complicated as the invoices can come in for an
entire order or for each order line or even worse a partial payment for
an order line. The other thing is the invoice list doesn't have the
order line only the order number and price, where as the first list
shows the order number, order line and price. Basically there's a 1-1,
1-many on many-1 relationship on an order line level. To make it more
complicated there's no limit on order lines per order and there's no
limit on how many invoices per order. Though one restriction is an
invoice will not come in to pay for 1 order line and part of another.
Also i need it to create a new table from list 2 of the invoice it
couldn't match.

Can anyone help me on this, i know its a bit long winded and
complicated but our company is totally backward and i don't think there
going to be a change in the process anytime soon.


--
DDONNI
------------------------------------------------------------------------
DDONNI's Profile: http://www.excelforum.com/member.php...o&userid=15443
View this thread: http://www.excelforum.com/showthread...hreadid=270406