| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Creating a drop down list to change decimal value in another cell
Hi guru's :o) I want to create a drop down list (with text: GBps, MBps, KBps etc) to change corresponding decimal value in another cell to update the entire spreadsheet with the new unit of measurement. I have attached an excerpt of the spreadsheet. Hopefully it will give you an idea of what i want to do. Thanks :o) +-------------------------------------------------------------------+ |Filename: B&B_Excerpt.zip | |Download: http://www.excelforum.com/attachment.php?postid=3574 | +-------------------------------------------------------------------+ -- DoD_au ------------------------------------------------------------------------ DoD_au's Profile: http://www.excelforum.com/member.php...fo&userid=3874 View this thread: http://www.excelforum.com/showthread...hreadid=384709 |
|
#2
|
|||
|
|||
|
1. Sample file: http://www.myexpertsonline.com/freedls/pricelist.xls
2. Data Validation for the dropdown: http://www.officearticles.com/excel/...soft_excel.htm 3. VLOOKUP to return the decimal value: http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "DoD_au" wrote in message ... Hi guru's :o) I want to create a drop down list (with text: GBps, MBps, KBps etc) to change corresponding decimal value in another cell to update the entire spreadsheet with the new unit of measurement. I have attached an excerpt of the spreadsheet. Hopefully it will give you an idea of what i want to do. Thanks :o) +-------------------------------------------------------------------+ |Filename: B&B_Excerpt.zip | |Download: http://www.excelforum.com/attachment.php?postid=3574 | +-------------------------------------------------------------------+ -- DoD_au ------------------------------------------------------------------------ DoD_au's Profile: http://www.excelforum.com/member.php...fo&userid=3874 View this thread: http://www.excelforum.com/showthread...hreadid=384709 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list with an if statement | Excel Worksheet Functions | |||
| Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
| How to change fonts in drop down list | Excel Discussion (Misc queries) | |||
| How do you create a drop down list? | Excel Discussion (Misc queries) | |||
| Drop List Referencing | Excel Worksheet Functions | |||
Linear Mode
