How to Select Last used cell and update data into that

I am trying to copy and paste the data from one sheet to another in same workbook. and for the same I need to find last used cell into 2nd Sheet and paste data after that.
can anyone please advice how to do this.

Below is my 1st Sheet from where i want to move the row.

Below is my targeted 2nd Sheet where i want to put the data after used cell 19.

image

Read success sheet into a data table using Read Range activity. (make sure headers is checked)
Get the next available row -> intAvailableRow = dt.Rows.Count + 2

Use the following activity to copy paste the input into success sheet.

Destination: "A" + intAvailableRows.ToString

Regards,
Karthik Byggari

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.