+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Group Outline steps - Without using subtotal

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Vail, Colorado
    MS-Off Ver
    Excel 2010
    Posts
    83

    Lightbulb Group Outline steps - Without using subtotal

    My data comes from an Access query. It is no problem formatting the data and sending it to an Excel 2007 Worksheet. Around 5,000 records.
    Any VBA programming is not a problem to recommend either.

    Data:
    1st Column: Sales Area
    2nd Column: CustomerID
    3rd, 4th 5th, 6th Columns: State, status, phone, type - all the same for each Customer ID
    7th, 8 Column: None, one, or many - TypeofSale, Status

    My goal is to group outline Column 1, and have a group to expand the Column 2, and column 2 can expand the single row for 3,4,5,6 (it is repeating data per customerID)
    And an expansion option to show the details of 7, 8

    I am going to automate this because each data pull is different.
    Trying to get away from the Customer_ID and other columns from showing the same data row by row just to display the unique data at the end. The Outline format seems to be what I am looking for.

    The Sub-Total in the Outline Ribbon allows a group on the change, but no sub-total (or other calc) are needed.
    Last edited by RxMiller; 06-02-2010 at 04:42 PM. Reason: Poor title, If I can figure out how to change it

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Need help with Group Outline steps

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    Hope that helps.

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

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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