I have a loop process to scrape data from a web and paste it into Excel and it looks like this.
Each data in red box got extracted from the loop process.
However, I need to write value inside the highlighted cell in green - which is in between of the extracted data. The number of rows in each extracted data is dynamic so I can’t set a specific cell to write the value.
The value is Day 1, Day 2 and so on respectively until the last day of the month.
I have tried Write Cell and Write Range activity but it keeps got overwritten by the extracted data.
Need your guidance please…