Is there a table somewhere in your workbook with some relationship between
the parts and the Model Number?
are the model Numbers "Smart" (IE:can you tell from the first character
something that would tell you that a specific part would be needed, etc.)
Would you want the parts to show up in the same column each time or just a
list right after the part number.

I appologize for asking so many questions, but to make th epart list there
needs to be sometthing to reference.

"Craig wotdoo" wrote:

I want to be able to add a different model number into a collum then have the
rows in that collum come up with those parts that that model uses as some of
these parts are used on severasl different models for example Model A uses
parts 1, 2, 3, 4 model B uses parts 2, 3, 5, 6 and model b uses parts 1, 2,
5, 6, ofcourse there a lot more model numbers and parts but what i want to be
able to do is type the model number in and have all the part numbers it uses
come up in the same row.