Concatenate and Count Values in Loop Function

Hello,

I'm working on a report that I am trying to have the number of students from a particular school listed in the header of that school. The problem I am having is that my "counter" isn't returning the value into the header and I keep getting a #Name error. I'm also not sure if it has something to do with not being able to get the true count without reading through all of the lines in the workbook.


Here's how the code works. It finds the word "Affiliation" then deletes this row to eliminate all of the table headers. Then it unmerges the header row. I am wanting to concatenate the School name with the number of people attached to that school. I've attached a sample workbook, so hopefully that makes more sense.

Please Login or Register  to view this content.

This was great. I was happy the "&" solved the name issue (I've got to get better with VBA Syntax) and working from Bottom up was definitely the way to go!

Thanks for your help!