Hi there. I was assigned a task which requires some numbers to process some information. Refer to the picture below, There are two sets of policy numbers (1st set from C9 to C23; 2nd set from C27 to C37). My questions are:
How could I set the code so that the robot knows to read the first row cell C9 and end with the last row cell C23 and store in the datatable1? The first row must be the row cell immediately below “Policy No.” (which might not necessarily be located in C8). The immediate row cell below the last row should always be blank (i.e. C24 in this case).
How could I set the code so that the robot knows to read the first row cell C27 and end with the last row cell C37 and store in the datatable2? Perhaps we could set the first row to be the row below “Fan Recoveries” (i.e. A26) and read the string in that row under Column C? Or are there better methods?
After storing the 2 sets of policy numbers in the two data tables. I need to use those value to perform search for new information. For that, I will create another two corresponding data tables to save the information inside them. Suppose I have save all values to those data table. I would like to input the value to Column J.
- For example, I will use the value in C9 to search new information. Let’s say the search result is “Good Performance”, the robot should input “Good Performance” under J9. Same for C29, the string of the search result should be pasted into J29. The problem is, how could I paste the first row of the data table into J9 and J27?
Many thanks for the help! Please let me know if there is anything unclear.