COM and/or VBA help needed

[tradeaj71]

Hi all.

My Excel workbooks need specific cells to show the odds for my unmatched and partially matched bets. At the moment I do this by using a Vlookup (or Match/Index) from a MyBets worksheet (using the "Log Current Bets"). For high turnover Horse races though, my workbook tends to become very clunky as the MyBets worksheet can extend to many thousands of rows of matched bets.

I am looking at ways of making these workbooks more efficient generally but streamlining the above would be a big help.

One thought is to enable the COM functionality and use =getBet formulae. Are there any known downsides to this (data usage maybe?). If not, I would be extremely grateful if a kind soul could provide the VBA code needed for me to use =getBet as a custom function in Excel.

Another way would be for the "MyBets" worksheet to exclude matched bets but I cannot see any way to do this.

Many thanks in advance.

[MollyMoo]

I know this is a bit late and don't know whether you solved this already, but I think I would use a VBA routine in the MyBets worksheet to fire whenever column E changed ("Matched") and then loop through the used cells in column E to populate your cells holding the unmatched/partially matched bets with all the cells' values in column E of MyBets sheet which <> "F".

[MollyMoo]

I mean the values from column D where column E <> "F"!!