Results 1 to 11 of 11

Creating a Non-contiguous list in a drop-dowm dynamically.!

Threaded View

Guest Creating a Non-contiguous... 05-25-2008, 04:06 AM
davesexcel Good Morning, try this it... 05-25-2008, 09:03 AM
Guest Your help is certainly... 05-25-2008, 09:34 AM
davesexcel Sorry I didn't notice the... 05-25-2008, 11:19 AM
Guest Dave 05-25-2008, 02:32 PM
davesexcel Did you try dragging the... 05-25-2008, 02:45 PM
Guest It did help but...! 05-25-2008, 03:11 PM
Guest Hey Dave, Did u try that,... 05-25-2008, 10:40 PM
Guest I am sorry Dave..! 05-26-2008, 01:15 AM
  1. 05-25-2008, 11:19 AM #4
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,523
    Quote Originally Posted by all4excel
    Your help is certainly appreciated...!
    However, Is it possible to get this done in MS Excel as I can understand the Excel comparatively better than VBA...

    This problem is a combinaation of Multiple Lookup and Dynamic Drop-down...

    I am able to get all the Tasks assigned to one person by using the logic for Multipe lokkup, but I dont know how to get the same in a Drop-down..

    I can get the Tasks assigned as follows:
    Sarah Activity 1A
    Activity 11A
    Actvity 111B
    Activity 2B

    But all the four Rows are relating to one person..Sarah..

    However in a Drop-down, the List would be for a single Row.

    So how do I solve this crux?
    Sorry I didn't notice the thread was in worksheet functions

    Unhide columns G:H to see the formulas
    select E2 to see the formula for your data validation
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1