I have 3 columns of excel with date.
First columns is the plate number of the car of the company
Second columns is the driver
Third the date that he drives.
With the first column I can open a screen for that car
Then I have to past the information of the second and third column in that screen.
I try to do that with a loop for each element of column A. I have the date of the column B&C in a variable list. But If I try to add in each loop to enter keystrokes and then select the variable I need to select the Index. But this index is a number.
How I can put a formula here, take the number in the same position as the number of loops executed. Or the same position as the plate number that was using in this case?