RE: A question involving attaching formulas

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
>
>

ok thanks, I'll try it right away

hm, no, that's not what i ment, sorry :/

the formulas have to appear when I typ the part that I want so I can use them x times. so if I would type:

(example)
________________basic royal <== tis is standard it represents the type
door____________148 150 <== these are the the results that have to appear because of the formulas that are attached to the 'door'
corpus__________298 310 " " "
etc


damn it's hard to explain :p

Hi Dries,
You might also look at combo box, see
http://www.contextures.com/tiptech.html
http://www.contextures.com/xlDataVal10.html
and introductory videos at
http://www.datapigtechnologies.com/ExcelMain.htm
Data Validation in Excel (1st half is on date, 2nd is on a list)

You can fill in more detail later from a table, like the price and weight using VLOOKUP
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
\Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"CLR" <[email protected]> wrote...
> 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.
>
> "Dries" wrote:
> > if I type 'Corpus' (or select it in some sort of a pop up menu)
> > the formulas (attached to it?) have to appear automatically
> > 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).
>

Hi Dries,
You might also look at combo box, see
http://www.contextures.com/tiptech.html
http://www.contextures.com/xlDataVal10.html
and introductory videos at
http://www.datapigtechnologies.com/ExcelMain.htm
Data Validation in Excel (1st half is on date, 2nd is on a list)

You can fill in more detail later from a table, like the price and weight using VLOOKUP
http://www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
\Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"CLR" <[email protected]> wrote...
> 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.
>
> "Dries" wrote:
> > if I type 'Corpus' (or select it in some sort of a pop up menu)
> > the formulas (attached to it?) have to appear automatically
> > 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).
>

thanks, I'll check it out