New Posts For Thread: Excel Help Pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-pleaseSheet one has a list of values in Column sorry lads I was away for a bit there, no one sheet is updated by myself manually and I want the other to update automatically. I am a bit busy fot the next couple of hrs but will give the suggestions a go, Many thanks to all!!!!https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420409022#420409022sorry lads I was away for a bit there, no one sheet is updated by myself manually and I want the other to update automatically. I am a bit busy fot the next couple of hrs but will give the suggestions a go, Many thanks to all!!!!Tue, 23 Feb 2010 05:17:10 -0600Bay Jesus, your solution is probably better as it will take into account if any cell in column m is blank.https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420409002#420409002Bay Jesus, your solution is probably better as it will take into account if any cell in column m is blank.Tue, 23 Feb 2010 05:06:43 -0600fkqmz, it's not m1 he wants every time. It's the last nonblank cell in column m.https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408990#420408990fkqmz, it's not m1 he wants every time. It's the last nonblank cell in column m.Tue, 23 Feb 2010 05:03:21 -0600=INDEX(Sheet1!M:M,MATCH(1E+30,Sheet1!M:M))https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408986#420408986=INDEX(Sheet1!M:M,MATCH(1E+30,Sheet1!M:M))Tue, 23 Feb 2010 04:48:56 -0600forgive if im missing something here but i have a similar spreadshhet that i use every day which downloads values. in my sheet to i simply enter ="(sheet 1 name)"!m1in d10 and as long as you have sheet 1 open, the d10 in sheet 2 will always show whathttps://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408982#420408982forgive if im missing something here but i have a similar spreadshhet that i use every day which downloads values. in my sheet to i simply enter ="(sheet 1 name)"!m1in d10 and as long as you have sheet 1 open, the d10 in sheet 2 will always show whatTue, 23 Feb 2010 04:47:20 -0600=INDIRECT("M"&COUNTA(M:M))https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408978#420408978=INDIRECT("M"&COUNTA(M:M))Tue, 23 Feb 2010 04:42:18 -0600Is sheet1 updated via a web query ?https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408974#420408974Is sheet1 updated via a web query ?Tue, 23 Feb 2010 04:41:38 -0600no mate, being honest i left it last night as it was annoying me lol. The numbers are currency figureshttps://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408970#420408970no mate, being honest i left it last night as it was annoying me lol. The numbers are currency figuresTue, 23 Feb 2010 04:27:41 -0600dlarssonf i know mate, its doing my head in but i will figure it outHave you worked out? If not then what type of data is in the cells you want to track?https://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408966#420408966dlarssonf i know mate, its doing my head in but i will figure it outHave you worked out? If not then what type of data is in the cells you want to track?Tue, 23 Feb 2010 04:24:19 -0600i know mate, its doing my head in but i will figure it outhttps://community.betfair.com/general_betting/go/thread/view/94082/23524650/excel-help-please?post_id=420408962#420408962i know mate, its doing my head in but i will figure it outMon, 22 Feb 2010 14:56:39 -0600