Hello! I have searched all the forum, and I did not found an answer to my problem...
I have a matrix, Column A is Items List and row 1 represents items I need to find out the number of items :Toy#78-Black ToyLO-100 - Green Skylla L900 BK KindleLS-Yellow MartianF400-Color KindleLX-100-Green Kindle#89Black KindleF90White KindleLX100Blue KindleF90Black MartianF300BK , etc...........
For example : Remanufactured for Toy #78: 2 Black + 1 of Each Color => that means that will be a 2 in B2 and a 1 in the intersection of column and row of the color ones ( the items can be green, yellow, etc.)
example 2: 2 New Remanufactured Black Toy Lo + 2 KindleLXGreen = > there must be number 2 in C2, and number 2 in cell G6.
How to create a macro that analizes the text in column A by line and them knows how many items I have and also Where to put them? ( Black = BK , Green, Yellow, etc.)
Than problem is that the text does not follow a rule.
Please help!
Thanks !
Bookmarks