Generate Numbers (not random) Like a counter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a Ticket Form for billing purposes. They need to generate
sequentially, but after the ticket is filled out and saved, the number can’t
change when it’s reopened. Would I have to use another program to do this or
could I get excel to work this out for me?
 
Presumably, your ticket form has a Ticket Number field. You would need to
create a macro of some sort which tells Excel "each time a new iteration of
this ticket form occurs, increase the value in the Ticket Numbe field by one."

Unfortunately my VBA skills are not up to snuff to tell you how to do that,
but I'm sure someone here can.
 
Back
Top