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.
Thanks in advance