I need a macro to track the number of students enrolled per month

  • Thread starter Thread starter islandgrl1984
  • Start date Start date
I

islandgrl1984

I am new to Excel and currently working on a spreadsheet to track the number
of students enrolled in our school per month. I already have all the
enrollement dates listed for each student but need a macro that will take
each date in that column, determine which month it falls in, and add it to
other like dates for a total by month to be listed on a new spreadsheet --
islandgrl1984
 
I would use the month function to break the month out of the date in a
separate column, then use the auto filter function to look at the data; or a
pivot table to do the reporting if you are feeling adventurous.

Boatman
 
Back
Top