I hope you are doing well. I am creating a quite (for me) difficult robot.
I have an Excel sheet where I have some data. I copy the data from somewhere else and search it in the Excel sheet by sending the hotkey ctrl+F. Then I press enter and find the data. Now I need the data from the first column in the row where I searched the first word (ctrl+f). This cell needs to be copied then as well but first of all I need a solution for the first case.
I share a screenshot which makes the problem more comprehensive:
Basically I search for the word “blabla” so that I get the row I need in order to find “uipath”. I am only allowed to use the word “blabla” to find “uipath”. Also external packages can’t be used as well like BalaReva or some others.
I would be very grateful if you can help me.