I hope finding solution for what I look for . so I searched to much in the internet like my thread , but I've found split column into multiple sheets and this is not suit in my case . my thread seems hard to achieve it and my knowladge in vba is too beginner. so I have sheet1,2 contain items in column B so should split into columns B,C,D based on matching in sheet MAIN . it should match cloumns B,C,D into sheet MAIN with column B into sheets1,2 then should split the the column into three columns for all items are existed in column B in both sheet1,2 . I put the expected result from column G: J into sheet1,2 and should change the headers based on the result .
note: ignore the columns contain headers (DEL,WHAR) into sheet1,2 also columns contain headers (arrived,sales,stock) into sheet MAIN when split .
so I truly appreciate if anybody answer this hard question .
thanks in advance