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.
 

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

automating use of complicated formula 4
Random Numbers 1
Quotation Marks as Text 2
Selecting more cells than I want 6
randomly select a cell from an array 6
Keep Losing My Cell Format 7
Locking Cells in an Automated SpreadSheet 1
Help separating letters from numbers 11

Back
Top