+ Reply to Thread
Results 1 to 5 of 5

Get data from different workbook

  1. #1
    Registered User
    Join Date
    09-21-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Get data from different workbook

    Well basically this is what i need. I a default excel sheet that I use for work and i create quotes on it. Everything is set up and at the top i have QUOTE PREPARED FOR:

    Now there I always have to type the persons name, number, etc.. But we usually have the same customers and there are like 45 of them. So I really dont feel like typing their information everytime I make a quote for them. Is it possible that maybe I can enter everyones information in one excel file and then when i go to my original excel file i can enter maybe a variable or something and i can get a persons contact info entered in there? Hope everyone understands what i am trying to do.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help! How can I get information from another excel file

    Hi,

    Create a master table of your customers, with in the left hand column the customer names, or perhaps their unique account code / ref. Then in the adjacent columns enter their various details like number, address, phone or whatever. Name this table say "Data"

    Then in your quote template use one cell in which you enter the customer name or account code and in the other cells you want populated use a VLOOKUP() function of the form:

    Please Login or Register  to view this content.
    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    09-21-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Get data from different workbook

    Richard,

    I really appreciate your help. I am very new to excel so can you explain step by step? Im sorry if I am asking for too much, I am learning .

    Thanks!

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Get data from different workbook

    Hi,

    Can you upload an example workbook for both your Quotation and your customer list showing what information you hold for each customer and the layout you hold it in. A few examples will be sufficient as long as they are representative.

    Rgds

  5. #5
    Registered User
    Join Date
    09-21-2009
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Get data from different workbook

    I have PM'ed you.

+ 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