How to read cell and choose in drop down

[sjvdr (sj)]

Hi, I want the robot to read cell B2 in one cell, and from the data, choose an option from another cell, D2 and i want this to repeat for a few rows. I have placed it inside a do-while activity, my problem is the read cell. it keeps reading the same first-row cell, B2, and doesn’t follow down is there a way for the robot to read the cell of the row I’m currently in. hence, the dropdown option for the following rows would be based on the read cell B2. I want it to if it reads B3, B4, B5 so on and so forth. please help me!!

[kumar.varun2 (Varun Kumar)]

Hi @sjvdr

Welcome to the UiPath Community.

This post can be useful for you.

How can I repeat the "type into activity" with each time another value to be inserted? without copy/paste the "type into activity"

Hello @mce Read the excel file into a Data Table using the Read Range Activity. The output of the read range activity is save in a Data Table variable. Now, you have to iterate through the rows of this Data Table, for this use For Each Row In Data Table Activity. Inside this activity’s body insert the Type Into activity The text that you want to type in is written in the cell of the excel file which has been read in a Data Table Variable and is now in iteration loop with one row at a time. …

Instead of type into you can add another activity according to your requirement.

[sjvdr (sj)]

hi. assuming cell b2 contains the drop down menu and d2 the cell that needs to be read.
i am using ctrl+G: to go to cell d2 and read the cell
then I am using hotkey to send the bot to b2 and choose an option
the option is chosen using a click activity( this has been placed in a dowhile activity, as I need this process to repeat for a few times)
i need the robot to read the cell that is on the same row as the drop down men so if I’m at b3 i need it to read cell d3. is there a way to do so. pls help.

[kumar.varun2 (Varun Kumar)]

Can you share the excel?