Hi friends

I have 26 different kinds of materials and each one could have nearly 200 different type of processing. That is to say for instance, I have column A holds 26 different kinds of material and column b holds 200 different kinds of processing. It is tedious to have a1 content to merge with each one of the 200 column b cells then a2 again...I tested by setting condition such as 'if ... then.' to make each kind of material to appear the time I desire. However, I know that there is a limit of setting conditioning. I think there will not be able for me to 26 x 200 'if ..then' I wish that someone could help me on this .

Thank you

lalaexcel