https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-pleaseI have a cell 'C32' that contains live data. The data changes about once a minute. What I want to do is record the data in 'C32' each time it changes. Then I want to record this data in a graph. Any help appreciated. Cheers.https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512349501#512349501Sorry for delay in getting back to you spreadsheet sent now.Wed, 09 Nov 2011 06:03:56 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512319669#512319669Gitmo,Thanks for your kind offer. PM sent.CheersTue, 08 Nov 2011 12:09:43 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512216109#512216109Dave, did you get a solution? If not, you could PM me your email address and I will send you a spreadsheet that collects and stores the information from a designated cell as it changes.Sun, 06 Nov 2011 07:39:09 -0600https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512136361#512136361I've not been able to get this working, column AV not updating with the new code. Thanks again for your help Compound Magic.Fri, 04 Nov 2011 13:58:08 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512083275#512083275Hi Compound Magic,I've tried replacing the old code with the new code (changing "M" to "AV" - I think that's all I have to do for the new code?) but nothing is happening. Column AV is not even updating if I click on the sheet. I take it that I don'tThu, 03 Nov 2011 12:16:00 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=512075705#512075705Hi dave bFinally solved the problem and have got it all working.I don't know where your Cell C32 is getting its information from, but this cell must be triggeredby excel and not by an API call.Have posted all the code that makes it work in Mr Excel ~Thu, 03 Nov 2011 09:16:20 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=511982409#511982409dave bWill be offline for quite a while but I have some ideas I am going to try.Had a google and found this that may be helpful. Using a change event to trigger a macro as in this thread ~http://www.ozgrid.com/VBA/run-macros-change.htmCheers.Tue, 01 Nov 2011 09:25:29 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=511980869#511980869..."C32" does not equal the last number...Tue, 01 Nov 2011 08:43:21 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=511980819#511980819Thanks for all your help and effort Compound Magic - it's appreciated!I was thinking could a macro be written that when "C32" the last number in range "AV" then cells "D32" then "E32" are chosen, thus acivating the update in column "AV"? Not sure hoTue, 01 Nov 2011 08:41:56 -0500https://community.betfair.com/general_betting/go/thread/view/94082/28637467/excel-help-please?post_id=511976613#511976613Hi dave b,Got my answer to my post on Mr Excel which explains why it was working for me in my own code but when hooked up toBetting Assistant it didn't.http://www.mrexcel.com/forum/showthread.php?t=589096Sorry about that.Well I tried!CheersTue, 01 Nov 2011 06:23:18 -0500