I would like to read and save a value from a specific cell neighbouring to one cell that is selected.
I.E. I enter a specific code that the robot finds in an excel sheet, then I want to read and save the value from the neighbour cell on the left hand side of it.
The cells are dynamic so it is not possible to select one static cell.
Hello, you can use a For Each Row activity to iterate through rows and then a For Each to iterate through columns, if the item matches the value you are looking for, you can extract the index of rows and columns and extract the element you are looking for.