Hi,
I'm struggling with the syntax for the "write to excel" action.
I want to write a series of values to a series of incrementing cells.
e.g.
value 1 goes to cell A20
value 2 goes to cell A21
value 3 goes to cell A22
I can produce the incrementing row number (row_index) variable, but I can't get the trigger to work with anything I have tried other than fixed cell references such as querymarket_id!A20. querymarket_id!Arow_index or querymarket_id!A_row_index don't do anything. What is the correct syntax if my user var is called row_index?
Also, I'm at a complete loss as to what the example in the manual does - querymarket_id!Dsel_index.
regards
Wez