Copying rows from different excel files in same folder location to one major file using For each loop

Since it’s in the loop, the datatable in write range gets overwrited by the next read range excel file.
Kindly help me coding the starting cell

@marsmanarin If you want, write to new sheet or new excel file so that data overwrite can be avoided.


You can use Merge Datatable or append range which will be better solution.
And the solution to your problem is to use Counter and increase the row count this will avoid overwrite.

Hope this will help you.

Suresh J