About dynamically write collection to excel with MS Excel VBO:write collection

[juiyulin1]

BP version : 7.0.1
Hello
I have a process about getting text from web as collection, and write it into excel row everyday, but it need to change to write next row every single day. For example: Today I write cell "M91toU91", tomorrow will need to write on "M92toU92", but hope can do it without insert a new row, is it possible to make it happened?
collection will be like following:

[shashank.kumar280 · Accepted solution]

@juiyulin1

There are some existing actions available in the MS Excel VBO that can help you with this.

- Go To Next Empty Cell Down
- Find Next Empty Cell
- Go To Cell
and more...

You might have to explore which action works best for you. But if you do a "Go To Cell​" to M91 and then "Go To Next Empty Cell Down", it should you to the immediate next empty cell below provided it's empty.