All sounds so complicated especially with the Notepad in the mix.
I thought I could have saddle, horse and odds data 3 columns in total, streaming from MFP via the Launch Excel function
on one sheet and at say avg. 10 horses per race and 30 races with headings
make up around 330-340 rows. all down columns A,B & C in the spreadsheet and refreshing every minute or so.
Then I would have the trigger execute data from other columns in the same spreadsheet which correspond with horse name
and bet amount in same row as the streamed data. Meaning if horse Frankel appeared in B12 from MFP. Then my formula would match same row
say cell E12 and Bet amount F12.
All of this without the need for VBA is that not so ?
Thanks for your patience Mark during this festive break. I think I need another glass of ginger wine