If you have a database with one row for each part for all of your products,
then you can add one column to indicate which product the part goes into,
such as "closet", Then you can do Data > Filter > AutoFilter, and select
"closet" in that product column and Excel will display only those parts that
are used in the "closet" product.
That's not exactly the answer to the questiion you asked, but if I
understand you correctly, that is the way I would do it.
hth
Vaya con Dios,
Chuck, CABGx3
"Dries" wrote:
>
> hello
>
> (I'm from belgium so my english therms might not be thát good)
>
> don't know where to start but I'll try, my problem is:
>
> They asked me to 'attach' formulas to words
> example; if I typ 'Corpus' (or select it in some sort of a pop up menu)
> the formulas (attached to it?) have to appear automaticly some cells
> further.
>
> actually it's for calculating prices, so if I want to calculate a
> certain closet, I have to choose the different parts (like corpus or
> door) with the different formulas attached (because there are different
> doors).
>
> it's kinda hard to explain I know
>
> can someone help me?
>
>
> --
> Dries
> ------------------------------------------------------------------------
> Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
> View this thread: http://www.excelforum.com/showthread...hreadid=521024
>
>
Bookmarks