If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 -- Dries ------------------------------------------------------------------------ Dries's Profile: http://www.excelforum.com/member.php...o&userid=32343 View this thread: http://www.excelforum.com/showthread...hreadid=521056 |
#5
|
|||
|
|||
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). |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multi - Level Question involving Data Mapping and Formulation | [email protected] | Worksheet Functions | 0 | September 6th, 2005 09:36 PM |
MVP Question (database Design & Server Requirements) | rayrock | Database Design | 3 | August 12th, 2005 02:45 AM |
Database Functions - question using formulas as criteria | msnews.microsoft.com | Worksheet Functions | 0 | June 9th, 2005 12:10 PM |
importing data and formulas into Excel | Eric | General Discussion | 2 | August 25th, 2004 12:12 AM |
Trouble with protected sheets & formulas | Peter Bernadyne | General Discussion | 6 | August 11th, 2004 02:54 PM |