Creating a drop down list to change decimal value in another cell

D

DoD_au

Hi guru's :blush:)

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 :blush:)


+-------------------------------------------------------------------+
|Filename: B&B_Excerpt.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3574 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down List Expertise please! 10
Linking a selection in a drop down list to a calc in another cell 6
Auto Fill Cells, When Choosing From Drop-Down List... 1
Control Display of Drop Down List in Validation 1
drop down list value changes 1
How do I change contents of a cell based on drop down list selecte 2
Drop down list selections creating values in adjoining cell 1
Using formulas to source a value based on 2 variables 2

Top