Hello,

My worksheet is setup with 3 columns multiple rows varying in length.
Example:

Col-1 Col-2 Col-3
AIR COMP AIR COMPRESSOR
CONVEYORS CONVEYORS
DKFTN DRINKING FOUNTAIN
DKFTN DRINKING FOUNTAIN
DOM TK-EL HOT WATER TANK-ELEC
EMER LIGHT EMERGENCY LIGHT
EMER LIGHT EMERGENCY LIGHT
EMER LIGHT EMERGENCY LIGHT

I would like number Col-1 in this format:

Col-1 Col-2 Col-3
001 AIR COMP AIR COMPRESSOR
001 CONVEYORS CONVEYORS
001 DKFTN DRINKING FOUNTAIN
002 DKFTN DRINKING FOUNTAIN
001 DOM TK-EL HOT WATER TANK-ELEC
001 EMER LIGHT EMERGENCY LIGHT
002 EMER LIGHT EMERGENCY LIGHT
003 EMER LIGHT EMERGENCY LIGHT

Some of my worksheets have a lot of data and i would like to use a
macro to insert the number for each item as example describes above.

Thank you for your help,
jfcby