Excel Automaion Scenario Based

You can count total# of rows in sheet2, after that -5 from total and store into a DT.
Now Read that DT and using write range to sheet1, it will come into first 5 rows.

Hope that helps.

1 Like