I got the address of marked cell using lookup range( output variable is address). now i want to write values to the cells in the rows below this column ( marked in red)?

Hi @Gaurav07

Use write cell activity and pass the output variable and range value as “”

Thanks
Ashwin.S

Ashwin you are not getting my question. take a look at the screenshot. My issue is -

  1. I took the value of month from user and saved in a variable called month.for example user inputs value as Feb-19.

  2. Now using lookup range I can find this value and reached at feb-19( circled in blue).

  3. Now I want to write values that I have stored in some data table in the cells below columns %splits and Barrels of the input month.how can I do that??

my guess is somehow we can manipulate the output variable of lookup range activity( which has the address of cell having value feb-19) to iterare through the rows below the cell.

Hi @Gaurav07

Then use assign

Row(“split”)=value
Row(“barrel”)=value

Then use write range

Thanks
Ashwin.S