Tieing in the Company and the products

[steppie70]

I need to know how to fix a work sheet so when I choose a Company that only
that company's parts list pop up in a drop down menu, I have gotten it to
where I can choose from a drop down menu for all products, but all is
combined (Every company we ship parts to). I need to Pick Comapny#1 and then
down in my Bill of Lading body, only that companies parts show up.

[Otto Moehrbach]

I assume that you are choosing the company from a Data Validation drop-down
list. Then, as you say, you want a second Data Validation drop-down list to
include only those parts pertinent to the chosen company.
Here's how.
Make a separate list of all the parts pertinent to each company. Name each
list the name of it's company. In other words, if the first list pertains
to Company1, name that list Company1, etc.
Note that all the company names must be listed as one word. For instance ,
say you have a company called First Public Trust. You must list that
company, in both the first list of companies as well as in the names of each
of the parts lists, as single words. For instance FirstPublicTrust. Or
anything else you want as long as it is just one word.
Then when you setup the second Data Validation cell, set it to list and in
the source block put "=INDIRECT(A5)" without the quotes (if A5 is the
location of the first Data Validation cell).
That's it.

If this doesn't work with your operation, you can use VBA and the company
names can be listed any way you want. Post back if you want to go with VBA
or if you need more. HTH Otto
"steppie70" <[email protected]> wrote in message
news:[email protected]...
>I need to know how to fix a work sheet so when I choose a Company that only
> that company's parts list pop up in a drop down menu, I have gotten it to
> where I can choose from a drop down menu for all products, but all is
> combined (Every company we ship parts to). I need to Pick Comapny#1 and
> then
> down in my Bill of Lading body, only that companies parts show up.