Most of the numbering jobs we do are DL tickets with a tear off stub, so each ticket has 2 numbers and they go 6 up on SRA3.

I have tried to make this work in InDesign any number of ways and here's the problem; to avoid collating individual tickets, sheet 1 has 001 top left, sheet 2 has 002 top left and so on. This means you just have to restack the blocks of sheets as you cut them and all your tickets are in order.

If you have 100 tickets to do that's 17 pages, so the second ticket on the sheet is 0018 (the rest follow on as you would expect). If you are doing 250 tickets the second ticket on the sheet is 0043. So the numbers on each sheet change depending on the total number of tickets required.

I started to do a template for 100 tickets, then one for 250, but we get orders for 130, 300, any kind of number and each one would need a new template.

Even linking from different excel sheets won't work because you need to link to different boxes on the sheet depending on the total number of tickets required, so again you have a different template for each total number required.

Quite quickly I realised the folly of this approach and we now use a numbering program which takes your PDF artwork, steps it up and places the numbers correctly depending on the total required. Much easier.