+ Reply to Thread
Results 1 to 6 of 6

Auto Populate Invoice

  1. 06-24-2011, 09:29 PM #1
    xzimbo
    xzimbo is offline
    Registered User
    Join Date
    06-24-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Auto Populate Invoice

    Hi,

    I'm a newbie at this and need help. I have a spreadsheet with 2 sheets: 1) Invoice and 2) Inventory. What I would like to do is, when I type in the part # in the invoice, I would like the Description and List Price to auto-populate with the appropriate data for that part #. Is it possible to do this. If so, would someone please show me how to do it. I've been through so many sites, I'm dizzy. I am attaching a sample file. Many, many thanks in advance for looking at it & possibly having a solution for me.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-25-2011, 04:23 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Auto Populate Invoice

    You need to use the VLOOKUP Function
    Hope that helps.

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

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 06-25-2011, 10:23 AM #3
    xzimbo
    xzimbo is offline
    Registered User
    Join Date
    06-24-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Auto Populate Invoice

    Thank you VERY much for your help.
    Reply With QuoteRegister To Reply
  4. 06-25-2011, 11:18 AM #4
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Auto Populate Invoice

    Hi xzimbo and welcome to the forum.

    See the attached where I've done two things to your Invoice.
    1. Validation Lookup in Column A of the Invoice Sheet. This way you don't need to type them.
    2. VLookup formula in Column E that will show a blank if the model isn't found.

    Keep learning and there are many more formulas to make Invoices easier.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  5. 06-25-2011, 11:41 AM #5
    xzimbo
    xzimbo is offline
    Registered User
    Join Date
    06-24-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Auto Populate Invoice

    Hi, MarvinP. This is most helpful. I was wondering how to remove those #N/A errors. I'm not quite sure how the Validation thing works, though...
    Reply With QuoteRegister To Reply
  6. 06-25-2011, 11:53 AM #6
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: Auto Populate Invoice

    Hi xzimbo,

    Look at the formula in E8. It is a "ISERROR" formula that was new in 2007. It says if something gives back an error then make it something else. I chose to make it blank if an error occured.

    Sooo, in F8 put this formula and pull down. 
    Please Login or Register  to view this content.
    Do a similar formula in F8.

    Here is the link to understand all about validation
    http://office.microsoft.com/en-us/ex...CH100648501033
    Or an easier site explaining Validation at
    http://www.contextures.com/xlDataVal01.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1