software

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: www.excelforum.com/member.php...oamp;userid=32343
View this thread: www.excelforum.com/showthread...hreadid=521024If 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 quot;closetquot;, Then you can do Data gt; Filter gt; AutoFilter, and select
quot;closetquot; in that product column and Excel will display only those parts that
are used in the quot;closetquot; 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
quot;Driesquot; wrote:

gt;
gt; hello
gt;
gt; (I'm from belgium so my english therms might not be thát good)
gt;
gt; don't know where to start but I'll try, my problem is:
gt;
gt; They asked me to 'attach' formulas to words
gt; example; if I typ 'Corpus' (or select it in some sort of a pop up menu)
gt; the formulas (attached to it?) have to appear automaticly some cells
gt; further.
gt;
gt; actually it's for calculating prices, so if I want to calculate a
gt; certain closet, I have to choose the different parts (like corpus or
gt; door) with the different formulas attached (because there are different
gt; doors).
gt;
gt; it's kinda hard to explain I know
gt;
gt; can someone help me?
gt;
gt;
gt; --
gt; Dries
gt; ------------------------------------------------------------------------
gt; Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
gt; View this thread: www.excelforum.com/showthread...hreadid=521024
gt;
gt;


ok thanks, I'll try it right away--
Dries
------------------------------------------------------------------------
Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
View this thread: www.excelforum.com/showthread...hreadid=521056
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 lt;== tis is standard it represents the
type
*door*____________148 150 lt;== these are the the results that have
to appear because of the formulas that are attached to the 'door'
*corpus*__________298 310 quot; quot; quot;
etcdamn it's hard to explain --
Dries
------------------------------------------------------------------------
Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
View this thread: www.excelforum.com/showthread...hreadid=521056Hi Dries,
You might also look at combo box, see
www.contextures.com/tiptech.html
www.contextures.com/xlDataVal10.html
and introductory videos at
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
www.mvps.org/dmcritchie/excel/vlookup.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
\Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;CLRquot; gt; wrote...
gt; such as quot;closetquot;, Then you can do Data gt; Filter gt; AutoFilter, and select
gt; quot;closetquot; in that product column and Excel will display only those parts that
gt; are used in the quot;closetquot; product.
gt;
gt; quot;Driesquot; wrote:
gt; gt; if I type 'Corpus' (or select it in some sort of a pop up menu)
gt; gt; the formulas (attached to it?) have to appear automatically
gt; gt; actually it's for calculating prices, so if I want to calculate a
gt; gt; certain closet, I have to choose the different parts (like corpus or
gt; gt; door) with the different formulas attached (because there are different
gt; gt; doors).
gt;

thanks, I'll check it out--
Dries
------------------------------------------------------------------------
Dries's Profile: www.excelforum.com/member.php...oamp;userid=32343
View this thread: www.excelforum.com/showthread...hreadid=521056