Quote Originally Posted by abdo meghari View Post
the only strategy I see should arrange the files when they are EXCEL files
So you misread post #23 !
According to 'tt' worksheet, what is the strategy to detect the data structure / the expected result worksheet layout ?

I already have one based only on your too small initial post attachment but no idea if could well work on the real data.
As I don't know which way to go, even using only Excel basics the code may have 150 codelines,
a way using more Excel formulas than the other, so in case you have to fit the code yourself
you may need all the summer and maybe the winter to well understand it ‼

And as my evaluating tool says a not go or waste my time, often it's right but maybe it's wrong 'cause of few data,
I already see a trap but I suspect another one - guessing time but as guessing can't be coding ! - so
maybe the reason of his negative return …


Quote Originally Posted by abdo meghari View Post
you mean in the same tt sheet?
I mean after the 'tt' data split and arrange VBA procedure if you manually modify a cell within this 'tt' worksheet
the relative split worksheet can be automatically updated - I was wrong yesterday - without launching
again the split and arrange procedure …


Quote Originally Posted by abdo meghari View Post
I hope you understanding the rest of details
As we are hoping you have enough well explained …


Quote Originally Posted by abdo meghari View Post
The maximum will be 2000 rows
So why not attach such workbook in particular if you are not able to elaborate the strategy ?
Save the workbook as binary format .xlsb in order to reduce its size, just in the state after such bad data importation …
Then I could better see the traps.
As a reminder, the more data attachment, the more chance you won't have to fit the 150 codelines - maybe more ! - yourself …