| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic job id number once enter a row
Hello
I'm working on a spreadsheet for a client that will be interactive via the web. I would like for the job id to be automatically entered once someone enters in a new row. Is there a way to do that? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatic job id number once enter a row
Hi
Say your job id's are currently until A300. Then, in A301:Ax you can enter =IF(B301="","",A300+1) HTH Kostis Vezerides On Jan 25, 9:53 pm, wrote: Hello I'm working on a spreadsheet for a client that will be interactive via the web. I would like for the job id to be automatically entered once someone enters in a new row. Is there a way to do that? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Automatic number generation. | Excel Discussion (Misc queries) | |||
| Setup Purchase Order Template to have a automatic number system? | Excel Worksheet Functions | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
Linear Mode
