Sheet example for place my bets

[mellenec]

I ran that example and I am wondering how the selections in the Selections sheet are placed in the main sheet.
Where is the code doing that?

[MarkRussell]

Hi,

The main sheet use Excel's VLOOKUP function to match your selection with the selection names from the market. That is why it very important to ensure that your selection names are exactly the same as on Betfair.

Regards,
Mark

[GaryRussell]

If you look at column Z on the Market worksheet you will see it uses a lookup formula to find the name on the Selection worksheet. This column will contain #N/A if it is not found otherwise it will contain the selection name. You will also see in column Q it makes the comparision "Z5=A5" to determine that the selection is present.