How to find last row cell value and copy in one excel to paste in another excel last row cell

[Raja.G (Mr.RPABot)]

HI Guys,

I need to copy last cell in particular column and paste to another excel last cell in particular column.

Can anyone help this

Regards,
Raja G

[Vish2148]

Hi @Raja.G ,

1. Read the excel and from the output variable of Readrange we can get rows count. If it is a table then we might get empty rows also so, in your condition if it is a table in excel then remove all empty rows that makes count of filled rows. Now, with the rows count you can directly go to the last datatrow and with help of column name you can extrat the last column value and can copy it. Save that value in variable and later then to another column cell in another excel.

Thanks,
Vish

[pattyricarte (Patty Boy)]

Hi @Raja.G

Theres a lot of way how to get that can we see your data please ?

cheers

Happy learning

[Raja.G (Mr.RPABot)]

This is my data’s

[pattyricarte (Patty Boy)]

you can get the count of the lastrow by converting your excel to datatable and count the data in the datatable.After that you can pass the value in the column.
DataTable.Rows(count)(0).ToString @Raja.G

cheers

Happy learning