Grouping data to create row headers

[jareda17]

Hello,
I have a spreadsheet that is pulling data from a database which contains information about people. This information contains things such as what College they have gone to as well as some other data used for calculations. In the worksheet that pulls the database data contains column "School_Names". Here is what I would like to do.

Since more than one person could go to the same school and new schools are added, I need to have an automated process that will look through the data and group these schools together (looking for new schools) on another worksheet as a heading. Below this heading will contain 6 rows of calculations based on other data associated with that person and school. I can't use a pivot table because I need to manually enter formulas to calculate results that I need.

Would look something like this:
SCHOOL NAME 1
Calculated data
Calculated data
Calculated data

SCHOOL NAME 2
Calculated data
Calculated data
Calculated data

and so on.

Is there a way to create some type of loop that will take each school name and set it as the title for that group of calculated data using VBA or something of the sort?

I've tried searching on this subject, but am not quite sure what else to search for besides Grouping which results in pivot table results. I hope it is clear what I am trying to do, but if not, I can try and re-explain. Thank you for the help.

Jared

[MarvinP]

Hi jareda17 and welcome to the forum,

If I understand your question correctly, I believe Excel has a feature to do exactly what you want.

Read
http://office.microsoft.com/en-us/ex...010095247.aspx

I don't think you need VBA code to do what you want.

[jareda17]

Thanks for the help. I think that will work for now.