Results 1 to 3 of 3

Lookup cell and copy entire cell, not the value

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Bangkok
    MS-Off Ver
    Excel 2007
    Posts
    22

    Lookup cell and copy entire cell, not the value

    Hey everyone,

    I have a very long list of names I should put into a dropdown list. In order to make it a bit clearer and shorter, my idea is that the user states the first character of the name and a dropdown list with only the names starting with this character will appear in a close-by cell.
    So I have a list of letters and dropdown lists like that:
    A I Dropdown list for names beginning with A
    B I Dropdown list for names beginning with B
    C I Dropdown list for names beginning with C
    ...
    Is there any possibility to use some kind of vlookup macro that copies the entire cell( with dropdownlist) related to the stated character.

    My macro starts like that:
    Private Sub Worksheet_Change(ByVal Target As Range)
    
       If Not Intersect(Target, Range("J7")) Is Nothing Then
       If Range("J7") = "" Then GoTo 123
    
    ????
    
    End If
    Range("D5").Select
    123
    End If
    End Sub
    Now I need to fill the blank in the middle :-D
    Thanks for your help!!

    The Intern
    Last edited by The Intern; 07-06-2011 at 11:59 PM.

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