Number sorting

  • Thread starter Thread starter ReD-DevIL
  • Start date Start date
R

ReD-DevIL

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 ?
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting CSV Data By Date 8
Form return lookup values 1
calculating percentage on timevalues 4
VB Code 4
Find then highlight in yellow 6
Calculation of Overlap Outage Hours 17
Combine 2 Charts 2007 Excel 1
2 dimensional date sort 1

Back
Top