I have 2 sheets of data from 2 separate databases:

DB A: roll_num, plate_date (step 1 of process)
DB B: roll_num, cut_date, cut_num (step 2 of process)

cut_num is unique for every data entry, but the roll_num stays with
roll its entire lifetime, therefore repeating several times in the dat
tables.

What I want to do is link the data sheets together to form one maste
table. This could done by taking the roll_num and cut_date in DB B an
matching it with the closest previous roll_num and plate_date in DB A
while deleting the repeated entries. Any ideas about how to implemen
this?

Sorry if this is unclear...I'll explain better if needed.

Thanks, Joe

--
Joe
-----------------------------------------------------------------------
JoeZ's Profile: http://www.excelforum.com/member.php...fo&userid=2291
View this thread: http://www.excelforum.com/showthread.php?threadid=46751