I need an excel macro that has a control panel that does the following: Divide Column X - a benchmark panel - by a range of other columns - up to 30 or 40 columns - stores the results in a new set of columns and then perform a set of simple statistical operations on those columns that are exported to simple Word Tables. The simple statistical operations should be for the entire column, and also for the column broken out for up to 20 separate criteria defined in another column. The stat operations are basic such as mean, median, minimum, maximum and ratio.
So, for example, the data in the spreadsheet might be for colleges in the USA. The benchmark column might be Total Number of Students Enrolled, and the other columns, say 100 columns, might be college spending on a range of items such as pensions, professors, sports programs, dormitories, etc etc. Dividing the benchmarks column by the spending columns would yield many columns of data such as spending per student on sports programs, spending per student on dormitories, spending per student on professors, etc etc.
Then we want this data broken down by various criteria such as colleges in different geographic locations, and colleges at different size levels, or different types of colleges, etc, etc. The program would be able to handle up to 20 separate data points per criteria.
he program should also generate the appropriate tables in Word.