Results 1 to 3 of 3

Creating an Invoice with different value on different client name (Newbie here)

Threaded View

cychua Creating an Invoice with... 08-28-2012, 05:37 AM
Richard Buttrey Re: Creating an Invoice with... 08-28-2012, 05:43 AM
cychua Re: Creating an Invoice with... 08-28-2012, 05:55 AM
  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    Klang, Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    113

    Creating an Invoice with different value on different client name (Newbie here)

    Hi All
    I am fresh and new for excel. Only basic calculation formulas, i am good with.
    Have been scratching my head for months to create an invoice as below shown. Hope that you guys willing to show me type of formulas to use and guidance.

    Excel Book 1 : Quotation : with the same service names (descriptions), but different pricing for different clients. Had saved on several excel files.
    Excel Book 2 : Invoice : Whenever i key my client name(ID), charges of the services price will appear automatically, by retrieving data from Book 1.

    I am stuck on invoicing. Wonder how to link the services price on the book 1 which quoted (based on customer name, from a numbers of quotation i have saved), whenever i type the name of the service on Book2/ Invoice.

    Hope that all the expertise here, will enlighten a noobie here.
    Thanks in advance.

    *Remarks
    Had tried to use the formula, VLOOKUP, it seems like working on a specific column only instead of the whole sheet with different type of services name.
    Example,
    1. hair washing
    2. Blowing
    3. Treatments

    Attached Files Attached Files
    Last edited by cychua; 08-28-2012 at 05:48 AM. Reason: Attaching sample files

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