hi
I would split data from sheet TIRES into multiple sheets based on first for two letters (FS,BS.....) into column B and when split data should arrange data the numbers from small to big.
so as you see in sheet BS when arrange. it should search the less number after R and arrange to big and should search the less number in the beginning item before letter R and arrange from small to big,also should replace data in divided sheet when change or add new data in sheet TIRES.
I put simple the result what I want after split in sheets BS,FS. but my true data in sheet TIRES are about 1000 rows and will increase
thanks
Bookmarks