I am trying to write a macro for my database in excel, however, i see it
needs better VB knowledge than mine, which is beginner in fact.

The details a

Three seperate sheets in a workbook, in each sheet there are 4 columns
(A1:A4) and over 5000 rows. an example is:
this is order receipts sheet

Shop Prod. Amount Rec. Date
KES Winx 20000 14.07.05
SA T&J 4998 05.07.05
KIR Batman 15000 11.06.05
OF Concept 40000 01.08.05

this is shipments sheet

Shop Prod. Amount Ship. Date
KES Winx 15000 15.08.05
KIR Batman 12000 13.06.05
SA T&J 5000 09.07.05
OF Concept 40000 09.08.05

now, in the third sheet i want to see the left-over orders and the time
between rec. and prod. date. The problem is, i cannot do this... can
anyone give me some clues???

*** Sent via Developersdex http://www.developersdex.com ***