A question involving attaching formulas
 

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

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

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

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

A question involving attaching formulas
 

ok thanks, I'll try it right away:)


--
Dries
------------------------------------------------------------------------
Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
View this thread: http://www.excelforum.com/showthread...hreadid=521056

A question involving attaching formulas
 

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


--
Dries
------------------------------------------------------------------------
Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
View this thread: http://www.excelforum.com/showthread...hreadid=521056

A question involving attaching formulas
 

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" 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).

A question involving attaching formulas
 

thanks, I'll check it out


--
Dries
------------------------------------------------------------------------
Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343
View this thread: http://www.excelforum.com/showthread...hreadid=521056