I’m trying to automate following steps;
Assume there is an Excel file and it has 3 columns, “date”, “customer number” and “status”
- Filter the Excel table using “date” column (say if it’s today)
- Get value of “customer number” column of each row and search the customer info on CRM system
- Get customer status info from CRM system screen and write it into “status” column
As to step no. 1 and 2, I was able to automate them by using “Filter Table”, “Read Range (enabled UseFilter option)”, “For Each Row”, “Get Row Item” and some other activities.
However, now I don’t know how to write “status” on a specific row.
Does anyone have any ideas?
*I think I can know row number if I give up using Fillter Table and use array to find rows which matches certain condition. But I don’t want to since I know it takes much more time; the Excel file contains about 4000 rows and about 200 rows will be processed in a day. It took more than 50 mins to just check “date” column of 3800 rows.