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.
Bookmarks