BACK & LAY Trigger Linking

[Castillo]

Hi All

I hope someone can help. I'm looking at the logging of individual prices export and using the information to trigger a BACK or LAY command in another excel spreadsheet. It’s probably best to explain using the Crossoversignal.xls spreadsheet available in the sample spreadsheets topic. This spreadsheet records a selections moving price and in column S depending on the price fluctuations it would display a BACK or LAY command accordingly. I don't know if it's possible but could I link the trigger to another cell in a different spreadsheet. The problem is a new line is created for each row of data so the Trigger command in column S is continually advancing one row S400, S401, S402 etc
So S256 might show BACK and S354 might show LAY, from a single cell in another spreadsheet is it possible to link to the triggers in the advancing S column. Hope I've explained this OK.

Many thanks,
Castillo