Thread
:
Autonumber from Form
View Single Post
#
3
Posted to microsoft.public.excel.newusers
flummi
Posts: n/a
Autonumber from Form
If you can incorporate a cell into your form you can do this:
Provided your lines entered are in A1:P100 and your running number is
in A1:
Use a cell somewhere say Q1 which will hold the next number to use:
=max(A:A)+1
Hans
Reply With Quote