Excel Green up

[mouse]

Capt Sensible or anyone

I need some advice to adapt Gary's sample spreadsheet Greenup-Auto to miy worksheet.
Say if I have an existing trigger of something like ......if this if that etc then back-t2-F5-IPC. that becomes matched.

How can I "add"/change gary's sheet so that green up occurs, either pre or in play, when the profit would be say £10 ?

thanx

[rourkem]

Bumping this up please if anyone can shed some light on this.

[mouse]

Gary or anyone

have had a go at adapting garys sample sheet Greenup-Auto.
I Changed the vba code to so that it can green up either pre or in play. and then My trigger in sheet1 Q5 is now along the lines of :
=if this, if that,etc etc, IF($T$2="Y",Y5,"")

The trouble is that i cannot test it since when i try to link to BA, i do not get the option to select sheet1 in the dialog box worksheet name, after log current prices.
I Am using version 1 30 15d.


Please advise. thanx

[bolpx001]

if I understand your correctly you want to link BA to sheet1 I found the best way to do this was to have the sheet you want to have linked as the first sheet in the spread sheet.

[mouse]

Now using version 1-3-018

Have put sheet 1 as my first sheet.
BA still does not give me the option to link to sheet 1. It only gives me the option to link to my results sheet !!

Really do need some help on this

thnx

[alrodopial]

Garry should answer this, there might be a problem with software installation , excel or ba
Try to bypass it using from ba the excel->log multiple sheets quick link

[Captain Sensible]

I'd guess there's some problem with the VBA coding in sheet1 that's stopping it from linking