Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoIncrementation
I have taken over the maintenance of a spread sheet which describes the
population of a treatment center. Each resident is assigned an ID code. As a new resident moves in he/she is assigned the next sequential ID. The ID's start as 00001. To prevent the dropping of the lead 0's, my predecessor formatted these ID"s as text. Since the spreadsheet is resorted several times a day, I want to make sure that the person responsible for maintaining the spreadsheet does not enter a duplicate ID number. The director of the center is not ready to change to a database. Any ideas? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoIncrementation
Hi
Have a look he http://www.cpearson.com/excel/NoDupEntry.htm Hope this helps. Andy. "Sol" wrote in message ... I have taken over the maintenance of a spread sheet which describes the population of a treatment center. Each resident is assigned an ID code. As a new resident moves in he/she is assigned the next sequential ID. The ID's start as 00001. To prevent the dropping of the lead 0's, my predecessor formatted these ID"s as text. Since the spreadsheet is resorted several times a day, I want to make sure that the person responsible for maintaining the spreadsheet does not enter a duplicate ID number. The director of the center is not ready to change to a database. Any ideas? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoIncrementation
Thanks. That helps a lot. But is there a way to have Excel enter the next
sequential number in the series using the parameters i set forth in my original post? "AndyB" wrote: Hi Have a look he http://www.cpearson.com/excel/NoDupEntry.htm Hope this helps. Andy. "Sol" wrote in message ... I have taken over the maintenance of a spread sheet which describes the population of a treatment center. Each resident is assigned an ID code. As a new resident moves in he/she is assigned the next sequential ID. The ID's start as 00001. To prevent the dropping of the lead 0's, my predecessor formatted these ID"s as text. Since the spreadsheet is resorted several times a day, I want to make sure that the person responsible for maintaining the spreadsheet does not enter a duplicate ID number. The director of the center is not ready to change to a database. Any ideas? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoIncrementation
You could have a 'trigger' cell that, when filled, automatically adds the
next number to the first column, I suppose. AndyB "Sol" wrote in message ... Thanks. That helps a lot. But is there a way to have Excel enter the next sequential number in the series using the parameters i set forth in my original post? "AndyB" wrote: Hi Have a look he http://www.cpearson.com/excel/NoDupEntry.htm Hope this helps. Andy. "Sol" wrote in message ... I have taken over the maintenance of a spread sheet which describes the population of a treatment center. Each resident is assigned an ID code. As a new resident moves in he/she is assigned the next sequential ID. The ID's start as 00001. To prevent the dropping of the lead 0's, my predecessor formatted these ID"s as text. Since the spreadsheet is resorted several times a day, I want to make sure that the person responsible for maintaining the spreadsheet does not enter a duplicate ID number. The director of the center is not ready to change to a database. Any ideas? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoIncrementation
=TEXT(A1,"00000")
"Sol" wrote: Thanks. That helps a lot. But is there a way to have Excel enter the next sequential number in the series using the parameters i set forth in my original post? "AndyB" wrote: Hi Have a look he http://www.cpearson.com/excel/NoDupEntry.htm Hope this helps. Andy. "Sol" wrote in message ... I have taken over the maintenance of a spread sheet which describes the population of a treatment center. Each resident is assigned an ID code. As a new resident moves in he/she is assigned the next sequential ID. The ID's start as 00001. To prevent the dropping of the lead 0's, my predecessor formatted these ID"s as text. Since the spreadsheet is resorted several times a day, I want to make sure that the person responsible for maintaining the spreadsheet does not enter a duplicate ID number. The director of the center is not ready to change to a database. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|