+ Reply to Thread
Results 1 to 2 of 2

"consolidate" spreadsheet full of invoice line details

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    USA
    MS-Off Ver
    2011 for Mac
    Posts
    6

    "consolidate" spreadsheet full of invoice line details

    I've got a spreadsheet full of invoice line details. The columns are things like Item #, Item Name, Invoice Date, Qty sold, Dollar amount, and Customer.

    I'm trying to consolidate it so it still shows *all* columns, but all sales for the same items to the same customer during the same month should be combined.

    So for example, if there are 3 separate rows for the same item sold to the same customer during the same month:
    Item # ABC, Item Name: Widget, Invoice date: 8/1/15, Qty sold: 30, dollar amt $30, Customer Acme
    Item # ABC, Item Name: Widget, Invoice date: 8/15/15, Qty sold: 20, dollar amt $20, Customer Acme
    Item # ABC, Item Name: Widget, Invoice date: 8/16/15, Qty sold: 50, dollar amt $50, Customer Acme

    I'd want that particular instance "consolidated" to just one line:
    Item # ABC, Item Name: Widget, Invoice month: Aug, Qty sold: 100 (total), dollar amt $100 (total), Customer Acme

    I've tried messing around with Pivot Tables and Consolidate, but can't figure out how to get from A to B. Any suggestions?

    (I'm using Excel 2011 on a Mac, OS: 10.11)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: "consolidate" spreadsheet full of invoice line details

    have you tried using SUBTOTAL function on the Data tab/Outline?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro works when using F8-"step into" line by line, but not when executing the full macro?
    By homecore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 05:07 PM
  2. Auomatically populating "Sheet2" when "Sheet1" is full
    By longbow007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-15-2013, 11:50 AM
  3. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  4. How to change "From" & to have a dynamic "Subject" line in Excel Mailing
    By andy_iyeng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-25-2012, 03:04 AM
  5. [SOLVED] Invoice "Current" or "Overdue" (but need "Paid" option)
    By rwatson in forum Excel General
    Replies: 5
    Last Post: 04-05-2012, 12:16 PM
  6. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  7. Replies: 0
    Last Post: 02-01-2006, 03:35 AM
  8. Replies: 1
    Last Post: 05-27-2005, 07:05 PM

Tags for this Thread

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