How to copy some rows from one file to the dynamic last row of another file?

[yangyq10 (IvanY)]

Dear Experts

I want to copy some rows for a sheet to dynamic last row of another file

For example, I want to past them from 7055

But I don’t know how to show lastrow+1

Can you give me some idea?

Thank you for your advise in advance

[ashokkarale]

@yangyq10,

You can use Find First/Last Data Row activity to get the last row number. Once you get it, you can easily do +1 to it and write the rows at last+1 row number.

Thanks,
Ashok

[yangyq10 (IvanY)]

@ashokkarale As you can see my screenshot I can’t figure out a correct way to do it…

[yangyq10 (IvanY)]

@ashokkarale Done

[ashokkarale]

@yangyq10,

Perfect! Happy automation!

Thanks,
Ashok