Copy whole row to another sheet

Help Studio
, ,
1

Hello,

I have to automate an excel sheet. In the excel there is column and row called “Column1 and Total”. I need to copy the entire Total row to another sheet but the position will changed (In the Total Row) Eg : Today Total row is in (A67), Tomorrow Total row will change to (A68)
Here with attached excel sheet.
Can anyone please advise me how to do this.
Sample.xlsx (8.1 KB)

2

@Udesheyy

Use Read Range activity to read the excel sheet and declare a variable for Datatable

Use Filter DataTable as below

image
image933×658 24 KB

This will filter the row with Total

If you want to write to other sheet, then use Append Range activity

Hope this may help you

Thanks

3

@Srini84

Thank you so much. It’s worked.
Another thing, I need to that Total row transpose to column. I used Data Transpose activity. But It’s not worked.
Can please advise me to do this.

4

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