+ Reply to Thread
Results 1 to 5 of 5

Address Book Help

  1. #1
    Registered User
    Join Date
    01-12-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Address Book Help

    I use an estimating excel book that has been passed around numerouse times, I have no clue on who the original author is in getting in touch with them.

    This is a form we use to right our proposals, I constantly have to retype the company name and address, is there a way I can make a drop down list and add them every time?
    I guess I am having trouble if I put all the company names on a new sheet with their address, how do I make a list on my proposal page to pick up those names, example.... and then drop them in my proposal page?

    ABC Construction
    123 Home St
    Chicago, IL

    BGH Construction
    321 Street
    Chicago, IL

    etc, etc, etc


    I am not sure if I can load my file since it is around 4mb.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Address Book Help

    You need a table setting up for the addresses. You can then use Data Validation Lists and 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
    01-12-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Address Book Help

    I am very basic to excel how would I set up a table for the addresses?

    I know I can make a sheet and put all the company address in there but how do I make the list just pick up the company name and then insert into all the required fields (name, address, phone number lines?)

  4. #4
    Registered User
    Join Date
    01-12-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Address Book Help

    After doing some research I made a table setting using my fields I want in each column. On my proposal page I made a drop down list where the company name can go and I can select from the list in my address book.

    This is were I am having trouble, how do I just use the drop down list to select my company and then under that in the corresponding cells the address, phone number, etc will be placed automatically, is this even possible?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Address Book Help

    Have you looked at the links that I posted & the example on the VLOOKUP page that demonstrates how to do what you want

+ 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