+ Reply to Thread
Results 1 to 3 of 3

dropdown

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    dropdown

    Hi Experts,
    I just need one thing when I select any specific address in yellow box columns then that specif address will remove from bottom list, please see screenshot and excel file you will better understand.

    Thanks in advance

    Farhangul
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: dropdown

    Formulas (and dropdowns) cannot affect any cell other than the 1 they reside in. For that, you will need VBA
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: dropdown

    can I again post this in VBA category?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Detect click on dropdown arrow in an activex dropdown box
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2017, 08:23 AM
  2. Dropdown selections based on adjacent dropdown selected
    By mtvufg8r in forum Excel General
    Replies: 2
    Last Post: 11-07-2014, 12:25 PM
  3. Data validation dropdown with in cell-dropdown?
    By OldManExcellor in forum Excel General
    Replies: 3
    Last Post: 09-16-2014, 08:14 AM
  4. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  5. [SOLVED] Cascading dropdown lists all tied to first dropdown
    By ruthl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-18-2012, 08:03 PM
  6. Replies: 2
    Last Post: 08-11-2011, 01:32 AM
  7. populating a dropdown based on choice from a previous dropdown
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 03:20 PM

Tags for this Thread

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