Posts by abdo meghari


    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


    I hope find solution in this forum

    the expected result in first sheet . the second sheet when data are not sorted. so it should sort entire row based on column B for each category .

    in column A contains category for many items in column B: last column .I said last column because of every month I issue new columns so when sort data should take considering this point and when sort data for each category (PSR (LRD),PSR (HRD),LTR,TBR) based on column B should sort for each category individually .

    the sort should be from small to big for three parts . for instance when sort category (PSR(LRD)) 175/70R13 should see to numbers for three sellebylles 175, 70 , 13 .it should sort from small to big . every time add new data for each category or create new category and new data for each new category

    shouls sort for each category individually based on column B

    note: each item contain last letter C should be below items don't contain last letter C as in category LTR

    I hope somebody help .