+ Reply to Thread
Results 1 to 2 of 2

Cell drop down and If formulas

  1. #1
    Registered User
    Join Date
    11-02-2007
    Posts
    1

    Cell drop down and If formulas

    I have a spreadsheet with data and all of it organized in cell drop down menus, all the information is on the same sheet. My problem at the moment is that I need a cell drop down menu to show different options, depending on whats in another menu above it. I.E. (numbers themselves are just examples, not my real data) cell A1 has drop down options of 0, 10, 20, 30, etc. now if cell A1 shows 0, I need cell B1 to have a drop down option of 1 through 9, and if A1 shows 10, I need B1's drop down to then show 11 through 19.

    I was planning to use an IF function for this, where if A1 equaled 0, B1 would show the drop down needed for it. However, B1 would change to whatever was in the drop down, but it wouldn't carry the drop down section with it. I'm having a difficult time with it and I can't find anything in a book or in the help function to help with a problem like this.
    another attempt to explain what I am doing. I have drop down lists and if statements with them way down near the end of the sheet. I need them to come to an area near the top according to what a drop down list near the top says.
    (so I need a drop down list to change the area below it to contain different drop down boxes and formulas)
    Drop down in cell A1 can do numbers one through 10. when it says 1, there are drop down lists in cells A2 and A3, as well as if formulas next to them for calculations. when A1 changes to say two, there is a drop down list in A4 and the lists in A2 and A3 have changed, as well as the formulas next to them)
    Last edited by Alsebiates; 11-02-2007 at 07:03 PM.

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See if link helps

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

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

+ 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