Excel list with range of values

[jakeman]

I'm working on a spreadsheet where a user enters ticket numbers for a raffle for a given customer. My data is currently in this format:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Customer
[/TD]
[TD]Ticket Issue Begin
[/TD]
[TD]Ticket Issue End
[/TD]
[TD]# of Tickets
[/TD]
[TD]Total Sale
[/TD]
[/TR]
[TR]
[TD]customer 1
[/TD]
[TD]'001
[/TD]
[TD]'002
[/TD]
[TD]2
[/TD]
[TD]$40 (2 tickets @ $20 a piece)
[/TD]
[/TR]
[TR]
[TD]customer 2
[/TD]
[TD]'003
[/TD]
[TD]'004
[/TD]
[TD]2
[/TD]
[TD]$40
[/TD]
[/TR]
</tbody>[/TABLE]

The problem with this format is there is room for error and the data entry person using this format can inadvertently use the same Ticket Issue Begin # or Ticket Issue End # or if the range of tickets spanned more than one ticket, some number in that range can be utilized without the user ever realizing this. I've warned the data entry user person of this and have recommended that each ticket be entered on a separate line to keep ticket #'s unique and eliminate errors. This way I could build a dynamic list of tickets that are decremented each time a number is used, so that number won't show up in the data validation list. However, the data entry user has insisted on this format.

So I'm really stuck on how to about solving for this problem and was wondering if anyone had any ideas or if someone has come across this problem before and knows a solution that worked.