Join our Premium Membership now and save with Xpres, Listawood, Ink Experts, Ink Express and more! Just £10 per year.....Click the Membership link above.....

User Tag List

Similar Threads

  1. Click and drop down again?
    By JMugs in forum Take a Break
    Replies: 9
    Last Post: 25-06-2018, 08:55 PM
  2. Click and drop down?
    By JMugs in forum Take a Break
    Replies: 8
    Last Post: 01-06-2018, 09:38 AM
  3. Excel - Exporting into Word
    By Justin in forum Software
    Replies: 5
    Last Post: 21-10-2014, 10:13 PM
  4. Ebay excel themselves yet again...
    By gstk in forum General Dye-Sub Chit Chat
    Replies: 9
    Last Post: 03-12-2012, 05:35 PM
  5. Drop shipping
    By jennywren in forum Copyright and other legal matters
    Replies: 7
    Last Post: 07-09-2012, 11:09 AM
Results 1 to 8 of 8
  1. #1
    Administrator Justin's Avatar
    Join Date
    Sep 2009
    Location
    Derbyshire
    Posts
    10,253
    Downloads
    7
    Uploads
    1
    Mentioned
    39 Post(s)
    Tagged
    7 Thread(s)

    Excel - Dependent Drop Down Lists

    Argh! This is doing my head in today, should be straight forward :-(

    I am creating a spreadsheet to track designers commissions. First column is the designers name, easy enough as a drop list. Then, the next section needs to show that particular designers work so I can track which design has sold. So, another drop down but this time it has to be dependant upon the name of the designer I choose.

    I found several tutorials, followed through no problem but when I try to work with my own data something is going wrong.

    https://trumpexcel.com/dependent-dro...list-in-excel/

    https://exceljet.net/dependent-dropdown-lists

    These are 2 tutorials which I'm following. Issue I have is when I define the =INDIRECT list. Always comes up with an error.

    Could anyone show me a quick sheet where this works please? Or maybe tell me where I'm going wrong.

    Attached Images Attached Images
    Membership scheme now available - Just £10 per year - Regular Supplier Discounts and Special Offers!

  2. #2
    Senior Member webtrekker's Avatar
    Join Date
    Sep 2016
    Location
    Northumberland
    Posts
    2,413
    Downloads
    0
    Uploads
    0
    Mentioned
    14 Post(s)
    Tagged
    3 Thread(s)
    I'm no Excel expert, but reading through the linked articles do any of your named ranges include spaces? They should be underscores, ie. John Smith should be John_Smith. Apparently spaces aren't allowed in named ranges.

    Don't know if that's of any help at all! :-)

  3. The Following User Says Thank You to webtrekker For This Useful Post:

    Justin (24-04-2019)

  4. #3
    Member
    Join Date
    Oct 2013
    Location
    Hampshire
    Posts
    173
    Downloads
    0
    Uploads
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi Justin,
    Had a quick look at the second tutorial & have it working. That's quite a useful tool.
    Just wondering if you have the "ranges" set up correctly. Look in Name Manager (Formulas -> Name manager) - is the data right?

    I expect your data is confidential, but if you want to DM a trial spreadsheet, I can look at it for you.
    Skye

  5. #4
    Administrator Justin's Avatar
    Join Date
    Sep 2009
    Location
    Derbyshire
    Posts
    10,253
    Downloads
    7
    Uploads
    1
    Mentioned
    39 Post(s)
    Tagged
    7 Thread(s)
    Quote Originally Posted by webtrekker View Post
    I'm no Excel expert, but reading through the linked articles do any of your named ranges include spaces? They should be underscores, ie. John Smith should be John_Smith. Apparently spaces aren't allowed in named ranges.)
    No, I noticed that so avoided spaces :-)
    Membership scheme now available - Just £10 per year - Regular Supplier Discounts and Special Offers!

  6. #5
    Administrator Justin's Avatar
    Join Date
    Sep 2009
    Location
    Derbyshire
    Posts
    10,253
    Downloads
    7
    Uploads
    1
    Mentioned
    39 Post(s)
    Tagged
    7 Thread(s)
    Quote Originally Posted by Skye View Post
    Hi Justin,
    Had a quick look at the second tutorial & have it working. That's quite a useful tool.
    Just wondering if you have the "ranges" set up correctly. Look in Name Manager (Formulas -> Name manager) - is the data right?

    I expect your data is confidential, but if you want to DM a trial spreadsheet, I can look at it for you.
    Skye
    Thanks Skye :-) Nah, nothing particularity confidential, just a list of names and designs really. I'm just playing to try and get it working with basic info before I populate.

    It's something silly I'm doing wrong, I can get a list of fruit and veg working no problem! Hahaha.
    Membership scheme now available - Just £10 per year - Regular Supplier Discounts and Special Offers!

  7. #6
    Member
    Join Date
    Oct 2013
    Location
    Hampshire
    Posts
    173
    Downloads
    0
    Uploads
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks Justin.

    Free feel to DM it later, if it doesn't work out.

    Skye

  8. The Following User Says Thank You to Skye For This Useful Post:

    Justin (24-04-2019)

  9. #7
    Administrator Justin's Avatar
    Join Date
    Sep 2009
    Location
    Derbyshire
    Posts
    10,253
    Downloads
    7
    Uploads
    1
    Mentioned
    39 Post(s)
    Tagged
    7 Thread(s)
    Many thanks for the input, after thinking I'd checked it was indeed just the space underscore issue! GGGRRR!
    Membership scheme now available - Just £10 per year - Regular Supplier Discounts and Special Offers!

  10. The Following User Says Thank You to Justin For This Useful Post:

    webtrekker (24-04-2019)

  11. #8
    Member
    Join Date
    Oct 2013
    Location
    Hampshire
    Posts
    173
    Downloads
    0
    Uploads
    0
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Justin,
    Good to hear you've sorted it out.
    Skye

  12. The Following User Says Thank You to Skye For This Useful Post:

    Justin (24-04-2019)

Posting Permissions

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