Automatic job id number once enter a row

  • Thread starter Thread starter mlm823
  • Start date Start date
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!
 
Hi

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

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

HTH
Kostis Vezerides
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
Autofill row with a column entry 3
Problem with Functions and Formulas 11
Finding duplicate numbers in a spreadsheet 2
Color a row once a "x" is entered 1
Sorting Columns/Rows Automatically 3
Conditional Formatting 2
Excel Populate Delivery Note 0

Back
Top