think through how you want to coding the products first before generating actual code numbers. for example: a combination of alphabet and numbers like AXY3456. -sannin99(雷蒙咨询) @渥太华华人论坛:渥太华枫下论坛 The Rolia Forum of Ottawa

think through how you want to coding the products first before generating actual code numbers. for example: a combination of alphabet and numbers like AXY3456.

Then use Vlookup function to bring up product details based on code assigned/typed in. -sannin99(雷蒙咨询) 2007-1-11