I have a workbook that has a sheet1 with product information, something like
this
Prod Length width Code
A 10 20 001
B 5 3 001

On another sheet I have a control that lets you select the Product and using
lookup functions I populate that sheet2 specific to the product chosen.

Each time sheet 2 is printed I need to issue a unique lot number for that
product. Our lot code system is 900x for 9 being 2009 and 00x being the
number of lots of that specific product we have produced in the year.

Is it possible to have the code increment by 1 each time that product is
printed? Then reset back to 001 at the beginning of the year?

Thanks in advance to anyone for help.
--
AJ