+ Reply to Thread
Results 1 to 4 of 4

Enter last name, auto fill full name & address--HOW?

  1. #1
    ana maria
    Guest

    Enter last name, auto fill full name & address--HOW?

    Hello,

    I'm trying to simplify a "customer info" form in which a commonly used
    individual and his/her full name, address, phone #s, etc. is required. Is
    there a method in which I can enter a keyword (preferably the individual's
    last name) and Excel will automatically insert his/her full name, address,
    etc.? There is a large list of individuals that require this shortcut.

    For Example:
    If I enter "Robertson", can Excel automatically enter (in place of
    "Robertson"):

    Mr. John Robertson
    111 Any Street
    Anytown, ON A1A 1A1
    Phone: (555) 555-5555
    Fax: (555) 555-5555
    Email: [email protected]


  2. #2
    Don Guillett
    Guest

    Re: Enter last name, auto fill full name & address--HOW?

    You can use vlookup functions or a worksheet_change event macro to do this.
    I would use the macro.

    --
    Don Guillett
    SalesAid Software
    [email protected]
    "ana maria" <ana [email protected]> wrote in message
    news:[email protected]...
    > Hello,
    >
    > I'm trying to simplify a "customer info" form in which a commonly used
    > individual and his/her full name, address, phone #s, etc. is required. Is
    > there a method in which I can enter a keyword (preferably the individual's
    > last name) and Excel will automatically insert his/her full name, address,
    > etc.? There is a large list of individuals that require this shortcut.
    >
    > For Example:
    > If I enter "Robertson", can Excel automatically enter (in place of
    > "Robertson"):
    >
    > Mr. John Robertson
    > 111 Any Street
    > Anytown, ON A1A 1A1
    > Phone: (555) 555-5555
    > Fax: (555) 555-5555
    > Email: [email protected]
    >




  3. #3
    Dave Breitenbach
    Guest

    RE: Enter last name, auto fill full name & address--HOW?

    Yes, set up a grid with all the information using horizontal column headers
    like, last name, first name, address1, address2, phone, etc. and then you can
    use the vlookup function on this list(pretty straightforward in help). One
    note though, vlookup always will look up the first column of your grid, so
    the last name should always be the first column.

    "ana maria" wrote:

    > Hello,
    >
    > I'm trying to simplify a "customer info" form in which a commonly used
    > individual and his/her full name, address, phone #s, etc. is required. Is
    > there a method in which I can enter a keyword (preferably the individual's
    > last name) and Excel will automatically insert his/her full name, address,
    > etc.? There is a large list of individuals that require this shortcut.
    >
    > For Example:
    > If I enter "Robertson", can Excel automatically enter (in place of
    > "Robertson"):
    >
    > Mr. John Robertson
    > 111 Any Street
    > Anytown, ON A1A 1A1
    > Phone: (555) 555-5555
    > Fax: (555) 555-5555
    > Email: [email protected]
    >


  4. #4
    cycling-rod
    Guest

    Re: Enter last name, auto fill full name & address--HOW?


    If you use Surnames, what will happen if you have 2 or more
    "Robertson's" Would it be best to give each name a serial number and
    use that to call up a person's details? Just a thought.


    --
    cycling-rod

+ 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