Hi, I have a serial number for every equipment.
E.g.
sno date
1 21-mar-06
2 22-mar-06
3 23-mar-06
Once the user delete the number 2 records, the number 3 will move up
but the serial number remains as 3 how can i code it to adjust the
serial number when a record is removed ?
--
ReD-DevIL
------------------------------------------------------------------------
ReD-DevIL's Profile:
http://www.excelforum.com/member.php...o&userid=32624
View this thread:
http://www.excelforum.com/showthread...hreadid=527973