How could I automate this workflow?

Hello guys.

The problem is that the position changes sometimes and I need to obtain the values (1,2,3) of id_canal,Id_biller and “configurado” .

Inside “Hoja1” the position is A6-B8. Inside “Hoja2” the new position is A15-B17.

image

image

I’m thinking about opening the excel file and use keyboard shortcuts ( Ctrl + B ) , look for Id _ canal , ID_Biller and configured but How could I move to the next cell that has the desired value.

test.xlsx (9.4 KB)

Please,any ideas, thanks.

Hi

How about to use LookUpRange activity as the following?

Regards,

1 Like