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