Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
First, i'm sorry for not doing the usual things like scouring the
annals of this group and lurking a long time before posting. I need some guidance and the sooner the better. What i want to build is basically a database. I need the names of all of the staff members i need to help train. I need the plan of action for each staff member. I need the dates, types and lengths of the trainings completed. I need to total the training times, with the possibility to separate the different types of training and total them also. I need an easy to read front page, with the ability to select any or all of the above data. First, is this do-able in Excel? I think it is, but I am having trouble wrapping my head around what seems to me to be a three dimensional matrix in two dimensions. I have very little exposure to excel, but i have some programming background and don't mind some syntax obstacles. My solution was a 100+ page workbook, each page being a different staff member. I couldn't figure how to get the data i needed from all of those pages into one display in the front. I'm sure there's a better way. Any help, including pointing me to other groups, pages, etc. is greatly appreciated. Also, if this can't be done, please help me understand why not. Thanks for taking the time to help me. bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Pointers to Formulas | Excel Discussion (Misc queries) | |||
Pointers?? | Excel Discussion (Misc queries) | |||
In excel pointers should be availible | Excel Worksheet Functions |