Green up in running

[excelhasey]

I have got your spreadsheet, thank you.

The problem is caused by using BACK-PL20-IP on the selections worksheet. This worksheet only expects BACK or LAY. I have corrected the spreadsheet and sent it back to you.
Note that cell AA2 on the Market worksheet contains the trigger modifier “-PL20-IP”. Note that the formula in column Q checks if AA9=”BACK”, it did not when AA9=”BACK-PL20-IP” which it did when the selections worksheet contained BACK-PL20-IP. This confused the formula and gave unpredictable results.

Are you saying that Trigger column Q wants to see just "BACK" not "BACK-PL20-IP" ?? - If so where does this data go ?? - What spreadsheet template have you downloaded to use as your sheet - I am confused ??

Thanks

[GaryRussell]

Are you saying that Trigger column Q wants to see just "BACK" not "BACK-PL20-IP" ?? - If so where does this data go ?? - What spreadsheet template have you downloaded to use as your sheet - I am confused ??

Thanks

They are using the example here http://gruss-software.co.uk/forum/viewtopic.php?t=3557 as a template. I am not referring to column Q. Please do not confuse this with a spreadsheet you have made yourself.

[Des911]

I wa out all day yesterday so was unable to try the sheet. I'll be able to do it today