I am looking for some help.
I am trying to do a for each row Loop from a data table. This is very easy to set up. However, the Excel file will get more and more rows (per append range activity). Now, if I start the for each row Loop it starts with row 1 again, but I don’t want to process These rows anymore. I want to process only the newly appended rows. I created a countrow variable which contains the number of rows that are in the Excel file before new rows are added, but how can I start the Loop with that variable from the newly appended row?
For example: I have 7 rows in the Excel file, all are already processed. Then, I append 3 more rows. Now I want to process These 3 newly appended rows and not start from the first row again. And then after that I add 5 more rows or 4 more rows (variable amount) and process them again.
Hope someone can help me