Biff,

Col A contains the "Date" of repair (from a drop down box)

Col J contains the "Type of Failure" (from a drop down box), i.e.
Supplier - Porosity

Col H contains the "Part # Failed" (from a drop down box), i.e. 31496 -
O-Ring

Thanks for your interest!

Frank


--
Racorfrank
------------------------------------------------------------------------
Racorfrank's Profile: http://www.excelforum.com/member.php...o&userid=17882
View this thread: http://www.excelforum.com/showthread...hreadid=479556