Copy data from one sheet to another sheet in Excel

Hello there,

i want to copy all the the data from one sheet of my Excel File to another sheet in the same File. The point is, that I often times don´t know how many rows there will be in my first sheet so i would have to calculate that in my programming in.
Can you please help me?

Kind regards!

1 Like

@mcLauge Use copy sheet activity.

i tried it with this activity, but apparently i need another (empty) sheet to copy the data, but i need to overwrite an existing sheet with the copied data. I also tried to read the range from the first sheet and with a write cell/ range activity to write it in the other sheet but that doesn´t work either.

I hope you understand me.

Kind regards!