Copy current market to list on market change vba

[Yorkie]

Hi

Need a little help please.

I need to create a list of the days races as they load into ba/excel

If ba is linked to sheet 1 and i want the list in sheet 2 then what i need to happen is

When ba is first loaded into excel cell A1 on sheet 1 is copied to cell A1 on sheet 2
When the market changes i need cell A1 on sheet 1 copied to A2 on sheet 2
When the market changes i need cell A1 on sheet 1 copied to A3 on sheet 2
etc etc.

Can someone point me in the right direction please.

Cheers guys

Yorkie

[alrodopial]

http://www.4shared.com/document/KmZV-uq ... BF-RP.html

the RP part is not working but the others do

[Yorkie]

Thanks but not really what i need, let me explain why i need it.

It's actually to be run on the dogs and what i want is to be able to load all the races in 1 tab, but i want to know the race number of each race at that track. So if the race list in ba started with

Sheff
Mon
Sheff
Mon

Then that would be

Sheff Race 1
Mon Race 1
Sheff Race 2
Mon Race 2
etc

By adding the current race, at market change, to a list which contains the previous races i can then determine that the current race is race number x at track y
I can do the excel formulas but i need help with the vba to create the list in the first place.

Yorkie