How to read 1 row from one sheet and write it in another sheet

Question

Hi all, I want to read one row at a time and write that entire value to another sheet:

Here, I want to copy only row 3 and paste that row 3 in another sheet then copy row 4 and paste it in another sheet and so, on
dt_table.Select(“row namw=‘3’”)(0)(1).ToString : I can fetch data using this but I am getting only one value can anyone help me

Answer 1

Hello, you can change the query like this:

dt_table.Select(“row name=‘3’”)

And add it a datatable so that you can use the write range activity. Then using write range you can write this datarow into the new sheet.