You will have to forgive any ignorance because, I am not a programmer. Here is what I need...
I have a large spreadsheet that lists scholarship funds for college students. Each fund has one row but, many columns. The columns contain the budget information, student info (for up to 25 students) and donor info (for up to 25 donors). It is a bit clunky but, we set it up that was so we could use it for mail merges. However, it is too large to quickly look at, print or determine quickly which scholarship has available funds. Therefore we need a summary sheet.
The summary sheet needs to list student and money info only (no donor info) but, each student needs to have their own row (transpose?). This means the funds may need to be listed more than once if more than one student has been awarded money from that fund.
I have included a smaller scale (10 funds) workbook that displays how we currently have the large spreadsheet (named ALL) and how I would like to see the summary sheet (named SUMMARY).
Any help would be greatly appreciated!
Bookmarks