Empty row issue

Help Activities
1

Dear Experts

Before I run the copy and paste operation, I already delete rows in my targeted sheet
PS: This is the process outside the for each activity

image

However, when I copy and paste from another sheet to targeted sheet(in for each), the 1st one always start from Row6(which is the last row before I delete rows at the beginning)

And the following rows are no issue while copy and paste

May I know how I can fix this issue?

PS: “Trans” is the another sheet, “Manage” is the targeted sheet

image

image
image850×727 26.4 KB

Thank you for your advise in advance :grinning:

2

Hi @yangyq10

In Copy/Paste Range activity Destination give Excel.Sheet(“Manage”).Range(“A2”)

Regards,

3

@lrtetala

Since its in a for each, if the we keep A2 in 2nd loop, it will overwrite the 1st loop data
I think sth is wrong about the empty rows which I can’t delete them clean and clear :cry:

4

@yangyq10

Try with Clear Sheet/Range/Table activity

The image displays an automated process sequence in an Excel workflow, opening "Excel1.xlsx," accessing Sheet1, and clearing its contents while preserving headers. (Captioned by AI)
The image displays an automated process sequence in an Excel workflow, opening "Excel1.xlsx," accessing Sheet1, and clearing its contents while preserving headers. (Captioned by AI)750×690 26.2 KB

Regards,

5

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