+ Reply to Thread
Results 1 to 2 of 2

Auto Fill Form

  1. #1
    Michael Coffee
    Guest

    Auto Fill Form

    Hello all-
    I need to create a form(Fax cover sheet) that will autofill the fax number
    and phone number when I type in a name. I have the data on sheet 2 that
    includes the name, fax number, and phone numbers in columns A, B, and C
    respectively. I have played around with a couple of different formulas, but
    have not been able to come across the correct combination. Any help would
    be greatly appreciated. This is a bit above my head.

    Thank you,

    Michael



  2. #2
    Forum Contributor
    Join Date
    01-06-2004
    Location
    Carbondale CO
    Posts
    245
    Michael,
    You need a drop downlist for your names. Take this link to find out how.

    http://www.contextures.com/xlDataVal01.html

    And then you need a VLOOKUP formula to fill in the phone and fax. To learn how take this link.

    http://www.contextures.com/xlFunctions02.html


    HTH
    Casey

+ 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