Automatic job id number once enter a row

M

mlm823

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!
 
V

vezerid

Hi

Say your job id's are currently until A300. Then, in A301:Ax you can
enter

=IF(B301="","",A300+1)

HTH
Kostis Vezerides
 
Top