Auto numbering tickes using excel

[DomingosHenriquez]

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?

[Barb Binder]

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

[Jeffrey_Smith]

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

[John Mensinger]

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.

[ashleew44226948]

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.)

[Colin Flashman]

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