mimitan
Technical User
- Dec 17, 2004
- 34
Hi,
I am trying to create a column that displays number reflecting the row number and because of reflecting the row number the digits in the cells are automatically changed at any time a row is inserted or deleted. For ex:
Rows 1-5 are headers
F_Name L_Name ID#
------------- ----------------- -------------
John Smith 6 (because it is at row 6 and so forth below)
Mary Roberts 7
Now let say I insert a person between John and Mary the ID# should automatically adjust itself as this
John Smith 6
Brian Jones 7
Mary Robberts 8
or if John is gone then Brian would be 6 and Mary would 7. I hope I make sense. Thanks for helps
I am trying to create a column that displays number reflecting the row number and because of reflecting the row number the digits in the cells are automatically changed at any time a row is inserted or deleted. For ex:
Rows 1-5 are headers
F_Name L_Name ID#
------------- ----------------- -------------
John Smith 6 (because it is at row 6 and so forth below)
Mary Roberts 7
Now let say I insert a person between John and Mary the ID# should automatically adjust itself as this
John Smith 6
Brian Jones 7
Mary Robberts 8
or if John is gone then Brian would be 6 and Mary would 7. I hope I make sense. Thanks for helps
