Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inputing and sorting Roster data
I deal with about 300 student information a week, from student IDs to contact
numbers, to meal codes and such. All information for the student needs to be sorted and distributed to different departments (i.e. cafateria, administration, nurse, etc...). I can do this all manually but it has become very cumbersom. I've learned that my actions can be recorded in macros, and this has helped a bit, but the problem is that there are multiple stages of sorting and inputing of data that requires me to create very complex functinos. Functions that I'm not capable of doing (i.e. I can't figure out the formulas). Verious types of sorting involves separating male from female, paid lunches from non-paid lunches, medical info, etc... Where can I go to get this set up the way I need it, so every time I'm given a list of raw information every week, I am able to open an application and all the proceedures and actions that I do to make the proper sorts and lists is done for me? In other words I need a one-stop-shop; a place that can give me answers quicker, because I have too many questions. I hope this wasn't too lengthy and difficult to read. Help would be great. |