+ Reply to Thread
Results 1 to 4 of 4

Lookup/Fill-in form ?

  1. #1
    Registered User
    Join Date
    12-02-2008
    Location
    Alaska
    Posts
    2

    Lookup/Fill-in form ?

    Hello,

    I'm having trouble trying to come up with a way to insert data fields into a spreadsheet form. I have a travel authorization form that I would like to have automatically fill in the required fields based on typing in a name. i.e. I would type in an employees name, and it would automatically fill-in the correct address, etc for that employee. I have attached a spreadsheet that contains one sheet as the form, and another sheet containing the employee data.

    I know nothing about VBA, but I have a feeling that is where I need to go...

    Any help is GREATLY appreciated !!!

    Thanks !

    Bob K.
    Anchorage, AK
    Attached Files Attached Files
    Last edited by Bob408SS; 12-02-2008 at 03:31 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    You don't need VBA, use VLOOKUP
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-02-2008
    Location
    Alaska
    Posts
    2
    Thanks a million !!!

    I knew it had to be a simple task, but I couldn't remember all the syntax for the VLOOKUP function. I got it !

    Thanks again !

    Bob K.
    Anchorage, AK

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    See if this helps

    http://www.excel-it.com/excel_functions.htm

    You could also use Data Validation to create a list of names to choose from

    Please mark the question solved

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1