View Single Post
  #1   Report Post  
DoD_au
 
Posts: n/a
Default 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