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
Bookmarks