Skip to main content
Participant
March 7, 2018
Question

Auto numbering tickes using excel

  • March 7, 2018
  • 5 replies
  • 797 views

I created 12 diferente tickets for the same event, if I use the auto numbering with excel data, there will be diferent tickets with the same number.
There is anyone who knows how to work around this problem?

This topic has been closed for replies.

5 replies

Colin Flashman
Community Expert
Community Expert
March 8, 2018

I'm assuming that Data Merge is being used to make these tickets.

I have a video on several ways to produce sequential numbers for Data Merge: Episode 6: Making Sequential Numbers for a Data Merge - YouTube

If you have made the numbers but are having issues with Data Merge and the multiple record feature, be aware that Data Merge doesn't do cut & stack style impositions. Again, I have a video that details my own solution to this problem: https://youtu.be/YNbtRsMZVQI

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
ashleew44226948
Inspiring
March 7, 2018

How is your spreadsheet currently set up? What you could do is create all the numbers, split them roughly equally across twelve columns, give each of those columns headers (set1, set 2, set3, etc) then assign one of those columns to each of your tickets when you're data merging.

(A better solution, if this is something you do frequently, is to use numbering software on the PDF once it's exported.)

John Mensinger
Community Expert
Community Expert
March 7, 2018

I'm not sure I understand the problem. Yes, if you use the same list of numbers for each of the 12 designs, it's a problem, but you can generate sequential lists in Excel rather than reusing the same one 12 times.

Community Expert
March 7, 2018

Could you use a prefix in your numbering scheme? Example A001, A002, A003, etc. then  B001, B002, B003, etc.

Barb Binder
Community Expert
Community Expert
March 7, 2018

Hi DomingosHenriquez~:

We are InDesign experts and not Excel experts. Someone here may well know the answer, but I suspect you will get a quicker response by asking this on the Excel forum: Results in Office - Microsoft Community

~Barb

~Barb at Rocky Mountain Training