+ Reply to Thread
Results 1 to 5 of 5

Need help on sorting or grouping for printing

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Need help on sorting or grouping for printing

    Need help on sorting or grouping for printing

    I have a file for daily sales for the whole month. I have around 40-50 customers. At the end of the end I want take a print out for each customer how much sales done and how much balance etc. I will doit for each customer separartely and take a print out. But it will end up in so many pages. I need a simplified method for sorting for each customer so that I can print it out all together to save paper.

    I have tried pivot table wizard, grouping sorting etc, none of them work for me

    I have attached the file for your reference. At the end I have just filtered for one customer.

    I need a help.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2013
    Posts
    8,647

    Re: Need help on sorting or grouping for printing

    How your end report for print to looks like?
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Need help on sorting or grouping for printing

    No standard format. But I need by customer wise, at the end of each customer just I need the total of all the columns like that.

  4. #4
    Registered User
    Join Date
    01-11-2013
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    59

    Re: Need help on sorting or grouping for printing

    Quote Originally Posted by vsravi.kmb View Post
    No standard format. But I need by customer wise, at the end of each customer just I need the total of all the columns like that.
    Friends,

    I need your help.

  5. #5
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Need help on sorting or grouping for printing

    I don't know what columns you want to include for the print. This could get you going. I created a new worksheet and in A1 of that worksheet is a Drop Down List that has all the names. Choose a name and the values for that name are presented.

    Delete the columns that you don't want and make the calculations that you want to include.
    Attached Files Attached Files
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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] Sorting while grouping
    By TamiT in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-24-2015, 12:43 PM
  2. [SOLVED] Sorting Data and Grouping
    By Forex-Forex in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2014, 05:19 PM
  3. [SOLVED] Sorting then grouping
    By gpowell in forum Excel General
    Replies: 6
    Last Post: 10-22-2013, 06:08 PM
  4. Automated Sorting and Grouping VBA
    By Pivo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 04:04 AM
  5. Help with grouping/sorting
    By ceverett in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-26-2011, 04:00 PM
  6. Excel 2007 : Grouping and Sorting
    By iPaprika in forum Excel General
    Replies: 0
    Last Post: 01-26-2011, 03:49 PM
  7. Grouping and Sorting Help!!!!
    By computerjunkie in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2007, 11:35 AM

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