Forum Discussion

Copper Contributor

Nov 22, 2018

EXCEL SEQUENTIAL NUMBERING ON FORMS

Hi everyone, is it possible to have sequential numbering on excel forms? EG. I have created Delivery Dockets via excel but need sequential numbering on these. It would be great if once 1 x is creat...

excel

erol sinan zorlu

Iron Contributor

Nov 23, 2018

Please check attached file.

This is a table that adds autonumber when some one enters a value in B2 cell.

AutoNumber.xlsx10 KB

tpengineering-2231

Copper Contributor

Nov 25, 2018

Hi everyone

Maybe I did not explain the question properly.

I was looking at sequential numbering on 1 x sheet at a time.

The same as if producing invoices in an accounting system.

Not sequential numbering per cell.

Thanks for your replies.

Selma :)

Damien_Rosario
Silver Contributor
Nov 25, 2018
Hi tpengineering-2231

Oh then I have nothing to help with that. Hopefully another expert on the forum might have something to assist you with.

Good luck and best wishes!

Cheers
Damien
- tpengineering-2231
  Copper Contributor
  Nov 25, 2018
  Ok. Thanks Damien.
  - erol sinan zorlu
    Iron Contributor
    Nov 26, 2018
    this is a difficult task, I have usually create a macro that does the job aside from other tasks like linking data. as any formula will cause a circular reference. which means these numbers will update themselves whenever they are recalculated at best.