Serial No will follow row number

[justin1202]

Hi, I need some assistance here. I have a list of Data and the data are as follows

ID Name D.O.B
1 Bob 01/02/1999
2 Tom 03/08/2000
3 Ben 04/09/2000
4 Paul 04/07/2001

And when I copy one of the data (e.g. row 2) over to a new sheet, it works. But when I create a new entry, the data will be like

ID Name D.O.B
1 Bob 01/02/1999
3 Ben 04/09/2000
4 Paul 04/07/2001
4 Jen 05/09/2001

The ID will follow the row number instead

I want the end results to be
ID Name D.O.B
1 Bob 01/02/1999
3 Ben 04/09/2000
4 Paul 04/07/2001
5 Jen 05/09/2001


Below is my code

Please Login or Register  to view this content.

[nilem]

Hi
try so

Please Login or Register  to view this content.

[justin1202]

Hi, it works perfectly.. Thank You

[justin1202]

Hi
try so

Please Login or Register  to view this content.

Hi, I would like to add on a question, may I know how to highlight a new entry row after based on the D.O.B year. Example year 1999, will be blue, year 2000 will be green and so on.

[bulina2k]

I would suggest Conditional Formatting for this task.
justin.jpg