Mike,
How is the number (and horse) selected ... because once
selected they can be placed on the ticket (or have I completely
misundertood?). Perhaps an example of the data layout would help clarify.

"Mike" wrote:

> Hi, I have a template in excel that prints out a ticket, what i want to do is
> change the content of the ticket by selecting a different number, to make it
> easier to explain the ticket is a bet put on a horse and states the Race
> number and horses name, so the name and number has to change for each race, i
> have the horses listed on a separate sheet and grouped into races, hope it
> makes sense to you.
>
> Mike