Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-13-2013, 02:57 PM
winter4400 winter4400 is offline Drop Down list with calculations and values Windows 7 64bit Drop Down list with calculations and values Office 2010 64bit
Novice
Drop Down list with calculations and values
 
Join Date: Jan 2013
Posts: 6
winter4400 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 01-14-2013, 07:21 AM
OTPM OTPM is offline Drop Down list with calculations and values Windows 7 32bit Drop Down list with calculations and values Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Attached Files
File Type: xlsx Unit Cost Calculations based on Drop Down List.xlsx (10.4 KB, 54 views)
Reply With Quote
  #3  
Old 01-14-2013, 07:23 AM
OTPM OTPM is offline Drop Down list with calculations and values Windows 7 32bit Drop Down list with calculations and values Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Also - you can embed the Excel Workbook in a Word document and it will work exactly as if you were in Excel.
Tony
Reply With Quote
  #4  
Old 01-14-2013, 02:54 PM
winter4400 winter4400 is offline Drop Down list with calculations and values Windows 7 64bit Drop Down list with calculations and values Office 2010 64bit
Novice
Drop Down list with calculations and values
 
Join Date: Jan 2013
Posts: 6
winter4400 is on a distinguished road
Default

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??
Reply With Quote
  #5  
Old 01-15-2013, 03:41 AM
OTPM OTPM is offline Drop Down list with calculations and values Windows 7 32bit Drop Down list with calculations and values Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 01-15-2013, 02:01 PM
winter4400 winter4400 is offline Drop Down list with calculations and values Windows 7 64bit Drop Down list with calculations and values Office 2010 64bit
Novice
Drop Down list with calculations and values
 
Join Date: Jan 2013
Posts: 6
winter4400 is on a distinguished road
Default

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?
Reply With Quote
  #7  
Old 01-16-2013, 04:54 AM
OTPM OTPM is offline Drop Down list with calculations and values Windows 7 32bit Drop Down list with calculations and values Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
  #8  
Old 01-16-2013, 04:55 AM
OTPM OTPM is offline Drop Down list with calculations and values Windows 7 32bit Drop Down list with calculations and values Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
calculating values, drop down lists

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop Down list with calculations and values Generate chart from list of text values knownunknown Excel 6 04-24-2013 01:56 AM
Drop Down list with calculations and values 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft