View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default 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!