+ Reply to Thread
Results 1 to 5 of 5

lookup values using VBA codes

  1. #1
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    lookup values using VBA codes

    Hi

    im not a master in vba codings and i am having a hard time on how to get for this code.

    i have attached the template and from summary tab, users are needed to enter their CIM ID and once the user enter their CIM, all campaigns are listed underneath and
    it will based it all under Data Tab.
    Attached Files Attached Files

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,794

    Re: lookup values using VBA codes

    Perhaps something like this?

    You fill in CIM ID in cell B2 "Symmary" sheet and when you press enter you get the updatred result. As it was not clear to me how you wanted the result to be you are getting all values i.e. A to C. This can be modified of cource.

    Alf
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-09-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    235

    Re: lookup values using VBA codes

    yes something like that but sir it is not working

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: lookup values using VBA codes

    Try the attached.
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: lookup values using VBA codes

    Another:

    Please Login or Register  to view this content.

+ 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. How can I use any one of multiple codes to lookup a product name?
    By Gelb1472 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-14-2012, 08:08 PM
  2. Lookup required to check codes closure dates
    By robertguy in forum Excel General
    Replies: 2
    Last Post: 07-23-2011, 08:23 AM
  3. Excel 2007 : Lookup:all area codes
    By hdlqepm in forum Excel General
    Replies: 2
    Last Post: 12-16-2009, 06:28 PM
  4. Macro to lookup many codes
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2008, 01:08 PM

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