copy from one excel spreadsheet to another without overwrite

  • 1 July 2022
  • 1 reply

Badge +3

I have a simple bot that opens two spreadsheets and copies the information from one to the other. The issue is that it completely overwrites the information on the destination spreadsheet rather than just adding new data to it. How do I get AA to locate the last line of data and paste all new data after that without over writing what was already there?

1 reply

Badge +3

Hi @dean mcghee​, there is this action called "go to next empty cell" in the Excel advanced package. imageUse this to find the next empty cell and write content in it.

I hope this helps.