+ Reply to Thread
Results 1 to 2 of 2

Assistance needed with drop downs in excel 2007

  1. #1
    Registered User
    Join Date
    05-05-2010
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    5

    Assistance needed with drop downs in excel 2007

    Morning guys,

    Need some help please. I am building a Performance Indicator Dashboard for my employer and trying to add some efficiencies into it. One area i am struggling with is regarding my drop downs. I want to set it up so that i have 2 drop down boxes, the first with the options for Quarter1,2,3 and 4 and the second with the 12 months of the year.

    What i want to happen from this is that if i select Quarter 1 for example ith will give me options in the 2nd drop down box of Jan, Feb or March, if i select Quarter 2 then i get options of Apr, May, June ETC. If there is anyone out there who could point me in the right direction i would be really greatful.

    Kind regards

    John

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111

    Re: Assistance needed with drop downs in excel 2007

    Evening John

    Try this

    http://www.contextures.com/xlDataVal02.html

    Cheers

    RC
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1