Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number sorting
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number sorting
Hi
For serial number 1 in A1 just type 1 For the second serial number type =A1 + 1 Fill this formula down and you will get the sequence 1, 2, 3, .. Deleting any row will re-number automatically as you required. regards Paul ReD-DevIL wrote: 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 ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number sorting
Hi, the sheet is created automatically every year so i cant type in th A1+1 manually. Is there any way i can do it using vba codes -- ReD-DevI ----------------------------------------------------------------------- ReD-DevIL's Profile: http://www.excelforum.com/member.php...fo&userid=3262 View this thread: http://www.excelforum.com/showthread.php?threadid=52797 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number sorting
Hi
You only type "=A1+1" once. Then you select the whole column from that point to the bottom of your data and do Edit, Fill, Down. regards Paul |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Number sorting
Ok, thanks for your help :) -- 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting by Number | Excel Worksheet Functions | |||
Number Sorting | Excel Discussion (Misc queries) | |||
VIN Number sorting | Excel Worksheet Functions | |||
sorting same model number | Excel Discussion (Misc queries) | |||
Sorting by Row Number? | Excel Worksheet Functions |