How to Update a value in a Specific cell of a row based on the condition of a value in a specific cell of another row

Hi @Anifowose_Temi

You have the row index already in index variable add 1 to it will give you the excel row value.

And you already know the excel column as the column would not change just append both of the together to get the cell value and use it in write cell

Say your column is B then B+(index+1).ToString is your excel cell value

Hope with this you resolved your issue

Cheers