Dear Joel,

It worked : )

All files with column2 data import are ok.

All files with column3 data import push last value to load against
next category.
Example if I have 805 entries in column3 in file 2.txt category name
is AB then it is showing 804 against AB and pushing the last cell
value to BB category i.e. file 3.txt

The reason that I understand is that file 3.txt has no data in line
10. I have removed the file number entry in Temp sheet meaning that
only files with data will be loaded & it will not cater blank file.
All is well now. : )


Thx for your valuable time & much needed support.
Appreciate that.