#1
|
|||
|
|||
Drop Down list with calculations and values
Hello,
I can't seem to find the answer to this anywhere and hoping someone can help. I have a document in Word 2010 that requires a set of drop down lists that self calculate. It would look like this Qty Uniform Description Unit Cost Total I would like to be able to put items such as Crew Shirt, Work Pants and Fleece Jacket under "Uniform Description" and have the "Unit Cost" auto fill with the appropriate amount i.e $5.00, $6.00, $10.00 then have the total column calculate the Unit Cost by the Qty entered. Can anyone guide me on this one. I am okay with the total and qty calculations (or at least I think I am) it is the value in the "Uniform Description" I seem to be having trouble with. Thanks! |
#2
|
|||
|
|||
Hi
Have a look at the sample Workbook attached. If you click on cell B2 in Sheet One and select an item, the unit cost will be automatically populated according to the selected item. If this is what you want let me know and I will explain how it is achieved. Tony |
#3
|
|||
|
|||
Also - you can embed the Excel Workbook in a Word document and it will work exactly as if you were in Excel.
Tony |
#4
|
|||
|
|||
That is exactly how I need it to work. I would need it in my word document and I do not know how to embed it??
|
#5
|
|||
|
|||
Hi
Follow these steps to embed the Excel solution in your Word document: 1. Place your cursor in the Word document at the point you want the Excel object to be displayed. 2. Select Insert followed by Object followed by Create From File. 3. Click on Browse and locate the Excel Workbook you wish to embed and click Insert. The Excel Object will then be inserted at the point of the cursor in your document. To activate (change) the entries in the workbook you simply double-click anywhere in the objdect and it cna be changed just as if you were inside Excel. Make your changes as required and click anywhere outside of the Excel object and your changes will be display in the Word document. If you have any further queries then please come back to the Forum. Good luck. Tony Last edited by OTPM; 01-15-2013 at 03:48 AM. Reason: Did not complete instructions. |
#6
|
|||
|
|||
Hi Tony,
No Luck on the embedding of excel file. I was able to get the file into my Word doc but I could not pick items from my drop down menu. It was just a "snapshot" of my file. Any suggestions? |
#7
|
|||
|
|||
Hi
Did you make sure you chose "Create From File" and then once it is in your document you double click on the workbook and it acts exactly as if you were in Excel. Just tested it here and it works fine. If still no luck can you send me a copy of your Word document and Excel file to tony.king@capita.co.uk and I will take a look for you. Tony |
#8
|
|||
|
|||
Hi
I have just tested it here and it works fine. Can you send me a copy of both documents to tony.king@capita.co.uk and I will take a look. Tony |
Tags |
calculating values, drop down lists |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Generate chart from list of text values | knownunknown | Excel | 6 | 04-24-2013 01:56 AM |
Perform Calculations using List boxes | Jennifer_Falcon | Word VBA | 6 | 07-26-2011 10:49 AM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Calculations using values from date picker controls | Inkarnate | Word | 0 | 06-09-2010 07:16 AM |
Fields controlled by List box values | farfromapro | Word | 0 | 02-11-2009 02:19 PM |