I have an Excel sheet with 3 columns.
Form Information Person 1 Person 2
Name Bob Dan
Address NY NJ
I have a form that has a Name field and an Address field.
I want the robot to fill out the form for Bob and Dan, respectively.
How can I have the robot do this? I want to use a For Each Column method because the Excel file format cannot be changed.
Thanks in advance!