New Posts For Thread: Gruss Excel help pleasehttps://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-pleaseI need some simple code that will put the trigger -1 into cell Q2 if cell V5 is not blank.I've searched the gruss forum but no joy and excel/vba code hurts my brain. Any help pleaseI don't know about Gruss, but if you open the vba editor and select ThisWorksheet the you can insert code that updates your sheet every time something happens. On the left drop down select Workbook, then either SheetChange or SheetCalculate. You canhttps://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545724385#545724385I don't know about Gruss, but if you open the vba editor and select ThisWorksheet the you can insert code that updates your sheet every time something happens. On the left drop down select Workbook, then either SheetChange or SheetCalculate. You canSat, 01 Aug 2015 06:30:05 -0500If you ever need future advice, speak to Gary or Mark.Their support is fantastic, and they always come back pronto.https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545724065#545724065If you ever need future advice, speak to Gary or Mark.Their support is fantastic, and they always come back pronto.Sat, 01 Aug 2015 05:49:40 -0500That went well!! I'm sure somebody on here will sort it.https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545724053#545724053That went well!! I'm sure somebody on here will sort it.Sat, 01 Aug 2015 05:48:32 -0500Thanks for the reply mate but if you use a formula it disappears when gruss refreshes, that's why i need code.cheers anywayhttps://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723765#545723765Thanks for the reply mate but if you use a formula it disappears when gruss refreshes, that's why i need code.cheers anywaySat, 01 Aug 2015 05:13:01 -0500=IF(V5 Smaller than/greater than"","",-1)https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723705#545723705=IF(V5 Smaller than/greater than"","",-1)Sat, 01 Aug 2015 05:05:34 -0500Oops, I misread the OPhttps://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723701#545723701Oops, I misread the OPSat, 01 Aug 2015 05:04:57 -0500=IF(V5 Smaller than/greater than"",-1,"")https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723691#545723691=IF(V5 Smaller than/greater than"",-1,"")Sat, 01 Aug 2015 05:04:09 -0500If(v5="","",-1) Other way round.https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723689#545723689If(v5="","",-1) Other way round.Sat, 01 Aug 2015 05:04:00 -0500It missed out the smaller than/greater than part of the formula that should be inserted between V5 and ""https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723683#545723683It missed out the smaller than/greater than part of the formula that should be inserted between V5 and ""Sat, 01 Aug 2015 05:03:11 -0500=IF(V5"",-1,"")https://community.betfair.com/chit_chat/go/thread/view/94038/30563563/gruss-excel-help-please?post_id=545723663#545723663=IF(V5"",-1,"")Sat, 01 Aug 2015 05:01:40 -0500