I was about to modify your example - great by the way that you attached, this way is always easier- but I have a few questions:
- What is the reason of you not knowing where the table starts?
- Will you append more data afterwards?
the first questions comes in mind because you as RPA analyst need to provide the solution for the client by giving them an standard format.
The second if its true will let you decide whether use append range or just use write range activity.
Then if you don’t know where the table will start and need to append more data, there are ways to achieve this, like read the table form, this by reading cells and find the first one and go from there(in this case I see that abc corporation will be the starting point)and then using a standard template move the information there and then you will be able to append the data normally.
and lastly the reason why it is inserting the data on those places is because it’s reading the ranges, formated as table, as if they have information.
please let me know, So I can start working on this.