Batch increase multiple sequential numbers on same page

[tmhubie]

Hi,

I am working on some stickers. See attached image for reference.

The document must contain 12 stickers per page.

I need to create 1000 stickers.

That gives me 83/84 pages.

Each sticker has an identifying number.

The numbers must run from  IE125110 - 126109

Is there some way to batch process this?

Thanks in advance.

[Eric Dumas]

Hi,

I would consider using the Data Merge option.

Using an MS Excel to easily list your numbers in a column, export it to CSV and use that.

In InDesign, there will be a bit of tweaking to make sure the rounded-corner frames and numbers land where you need, it would spread fast the large quantity that you need.

https://helpx.adobe.com/ie/indesign/using/data-merge.html

[tmhubie]

EDIT: I figured out the excel sequence. 

Hi Eric,

Thanks for your reply.

I was thinking about doing that. Do you know anyway to create 5000 sequential numbers in excel? 🙂

[Colin Flashman]

I've made a YouTube tutorial on preparing sequential numbers using several methods using Excel: https://youtu.be/46kohf51v1I

[tmhubie]

This worked me thanks

[Kasyan Servetsky]

Check out the Numbering script by Jared Katz.

[tmhubie]

Thanks for the info 🙂

[jmlevy]

Easy to do with a numbered list.

Create 12 frames on a master page, apply the paragraph style to each (before duplicating the first frame, type a space to generate the automatic numbering). Create the pages, then select all the pages in the pages panel > 

[tmhubie]

Thank you for replying and the info

Colin_Flashman video above worked for me but i think ill try your advice too to see which works best 🙂