ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating a drop down list to change decimal value in another cell (https://www.excelbanter.com/excel-worksheet-functions/33922-creating-drop-down-list-change-decimal-value-another-cell.html)

DoD_au

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


Anne Troy

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





All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com