Basically there are aprox 30 models with around 300 parts at the moment there
is a spreadsheet with the partnumbers followed by the model that each part
goes on, for some parts this is up to 20 models.
in the same row each time i guess for example like this

MON
Model A B C
TX 1 8 9
SX 1 7 10
RX 4 7 9

Each day the model's will change but part numbers for each model will remain
the same



"bj" wrote:

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.