Excel VBA problem - Date Selection

[rmo5354]

I have 2 Excel tables, part of the first table looks as follows. I kee
track of parts in production by entering completion dates for eac
process they go through.

S/N Kitting SMT 1st Assembly Inspection
10001 30-Jun 2-Jul 8-Jul
10002 24-Jun 27-Jun
10003

Note: This table needs to be flexible in terms of the number of S/N'
as well the number of processes entered. For example, there could b
15 processes parts need to go through. In addition, there could be 1
identical parts in production.

I need help writing a macro which will go through each line and take
the latest completion date and also the process name, into the tabl
below, which I need to import into an Access database:

S/N Last Date Process
10001 July 8, 2004 1st Assembly
10002 June 27, 2004 SMT
10003 Not Yet Started

I appreciate any hel

 

[rmo5354]

I attached the excel file as the tables did not line up correctly i
plain tex

Attachment filename: partstatus.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63853