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.

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.

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.

in your response it looks like you might use different numbers of the
different parts in each model, do you want this indicated also?
If you have 300 parts you can't have one column per part number, so you
obviously need to eliminate blanks between parts.
I believe you will need VBA code to do what you want.

I will try to put something to gether and send another response later.



"Craig" wrote:

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.

Thank's very much it's good to see people with knowledge helping others out
i'll start looking into it.

"bj" wrote:

in your response it looks like you might use different numbers of the
different parts in each model, do you want this indicated also?
If you have 300 parts you can't have one column per part number, so you
obviously need to eliminate blanks between parts.
I believe you will need VBA code to do what you want.

I will try to put something to gether and send another response later.



"Craig" wrote:

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.