I want to update excel cell for column X based on whatever the result comes in for Column Y.
See flow below:
Read Excel file
Filter Excel File and get only Column A, P, T
Want to process each row from column A
IF column A process sucess - then update Excel column T(Status)'s row for the same row of A (A2=T2)
IF Fail, update excel column T2 .
I am confused in writing the range as I don’t know how to get cell number to update value.
Hey I solved it but for that lookup range I’ve to open Excel Each time which might cause an issue because I have multiple records. Is there any way that I can update cell records without opening Excel?