Excel Exporting. Race Number

[Haviton]

I want to export the prices to an excel sheet which I know how to do

However, I need the race card number to have its own cell in excel. Is this possible.

Thanks in advance for any help

[GaryRussell]

When you set up the Excel link there is a list of additional columns to select. Tick race card number in this list.

[Haviton]

Thanks for your reply Gary

I have looked at the columns and see no "Race Card Number" in the list.

I did select saddle cloth but still couldnt see any number relevant to the horses number?
Thanks

[Captain Sensible]

The saddle cloth number is the one and gets exported to the excel sheet at the first available column at the end of the data so will show up around column Y'ish . Do you have any hidden columns or VBA that may be overwriting it?

[Haviton]

Thanks again but its still not working.

I even clicked "Owner" to try and have sopme words appear in the spreadsheet as well to help differentiate from the numbers.

In column "X" there is a row of "0"s but in Y and beyond, there is nothing.

This is a brand new spread sheet and I dont know what VBA is sorry but I wouldnt think I have any

Thanks

[Captain Sensible]

Have you got Enable triggered betting ticked ? I think the additional columns only work once that's ticked . Otherwise what version do you have?

[Haviton]

CS

Many thanks

Enable Trigger Betting Ticked and all sorted.

MANY thanks