Results 1 to 4 of 4

Lookup name in list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    Netherlands
    MS-Off Ver
    Office 365 (2013)
    Posts
    268

    Lookup name in list

    Hey,

    I'm really bad in VBA, but I think its fun to try some things.
    Got a script now so when someone types in a new range of info, it will be added in the datasheet

    This datasheet looks like this:
    [number] [name] [surname] [adress] [extrainfo]
    [1] [Frans] [Flipkip] [whocares] [ ]
    [2] [Tony] [Mafkees] [noidea] [ ]

    When I have Flipkip on my first page in a cell (say A1) <-- this cell is always the same
    And info in cell A2
    Then I want, when I press a button, to return the info from cell A2 into datasheet extrainfo column in row 2

    When I have Mafkees on my first page in a cell (say A1)
    And info in cell A2
    Then I want, when I press a button, to return the info from cell A2 into datasheet extrainfo column in row 3

    If someone tells me to upload an example I will have to disappoint him/her. My sheet is so confusing that I can better just try and explain it, so I have 2% chance someone will understand it and is willing to help.
    Last edited by Evolta; 09-17-2013 at 09:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup a value in list and return a value from the same list
    By ahsng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2012, 04:34 PM
  2. lookup list
    By loner2003 in forum Excel General
    Replies: 7
    Last Post: 03-11-2010, 12:19 PM
  3. Lookup Last Value in List
    By kasimagj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-02-2008, 05:52 PM
  4. Lookup and list
    By Voodoodan in forum Excel General
    Replies: 5
    Last Post: 05-25-2006, 02:10 PM
  5. Lookup a cell in a list to see if it is in the list
    By quimrider in forum Excel General
    Replies: 3
    Last Post: 12-09-2005, 02:06 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