+ Reply to Thread
Results 1 to 13 of 13

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

  1. 07-05-2005, 06:07 PM #1
    DoD_au
    DoD_au is offline
    Registered User
    Join Date
    12-15-2003
    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)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-05-2005, 08:05 PM #2
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  3. 09-05-2005, 10:05 PM #3
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  4. 09-05-2005, 11:05 PM #4
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  5. 09-06-2005, 12:05 AM #5
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  6. 09-06-2005, 01:05 AM #6
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  7. 09-06-2005, 02:05 AM #7
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  8. 09-06-2005, 03:05 AM #8
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  9. 09-06-2005, 04:05 AM #9
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  10. 09-06-2005, 06:05 AM #10
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  11. 09-06-2005, 07:05 AM #11
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  12. 09-06-2005, 10:05 AM #12
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
  13. 09-06-2005, 12:05 PM #13
    Anne Troy
    Guest

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

    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" <DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com> wrote in
    message news:DoD_au.1rpyil_1120604735.0607@excelforum-nospam.com...
    >
    > 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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1