open file names from excel file

[junjie]

hi bro,
i want to keep the headers in the destination file ... so, the destination range will be revised how ?

View attachment 1535537623978.png

 

[VJR]

In the destination range provide A2.

 

[junjie]

hi bro
after I change to : "A2" & [Last row file1]
it becomes cell A21
because the destination file 1 , initially we have 1 header row, and the value counted is 1.
putting "A2" & [Last row file1 , this becomes cell A21
the data is pasted starting at cell A21 onwards

 

[VJR]

hi bro
after I change to : "A2" & [Last row file1]
it becomes cell A21
because the destination file 1 , initially we have 1 header row, and the value counted is 1.
putting "A2" & [Last row file1 , this becomes cell A21
the data is pasted starting at cell A21 onwards

You have to put only A2.

 

[junjie]

hi bro
I put only A2, and it works, but only for the 1st loop
the 2nd loop, it overwrites the first paste and start at A2 again

 

[VJR]

hi bro
I put only A2, and it works, but only for the 1st loop
the 2nd loop, it overwrites the first paste and start at A2 again

For that purpose you need to make use of the last row.
- find last row
- then use [A]&[LastRow] + 1

 

[junjie]

oh yeahhh it works
thank you