+ Reply to Thread
Results 1 to 3 of 3

dropdwown

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

    dropdwown

    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

    Farhan
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    646

    Re: dropdwown

    Please check in cel A110 & B110, there were some formula there.
    Regards,
    Thangavel D

    Appreciate the help? CLICK *

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: dropdwown

    There was an issue with deleting the row, it screws up your array formulas.

    I have changed it a bit, when you select the Teritory, the list is replaced from A111 down. Then a list range is updated, and that list range is used for your data validation.

    When selecting something from the data validation, that selection will get deleted from the bottom list.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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