Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel problem...help!!!
hi there everyone... i have a big problem about excel now... wondering anyone could help me or not... Well, i'll try to tell u the story from top to bottom first... First of all, pls look at the diagram below : [image: http://i7.photobucket.com/albums/y283/cloudet/scan.jpg] I want to develop a system for keying in data for all of the students in a college using excel, but i want to make it as compatible as access where the raw data that will be inserted from the raw data table will automatically updated the three table that i've mentioned in the diagram above.In three of the table contains all of the available student id....but in the raw data table there are only a few student who took the exam in one month(iamgine this table is only for one subject)....so not all of the data in the three other table will be updated automatically(because all of the other three table contains all of the stud id in the college)....hmmmm...i could do this manually by checking which one must be updated n which one don't....but it took a lot of time...can i have any button where i could click, n then it will automatically sort n updated the other three tables..... my second problem is that, what if the year ended 2005???will it automatically create a new table consists of the same stud ID....BUT i still want to keep the old data in 2005. Because the summarized table will contain all of the data for one year only. Should i create many summarized table from 2005 till 2020.....??????? :roll: If u can, pls make it easier for me to update n no need for me to continouosly create a new table for each month(for the pass n fail table) and every year(for the summarized table).....because, then i need to compile the summarized table in a graph report where i could see wether there is a decrease or increase in the student's performance.(pass or fail) of course it will be easier if u do it in access, because it will auto update the related rows according to the studID but i must do this in EXCEL bcoz I MUST..... :roll: lol... -- cloudet ------------------------------------------------------------------------ cloudet's Profile: http://www.excelforum.com/member.php...o&userid=22362 View this thread: http://www.excelforum.com/showthread...hreadid=381102 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Problem viewing Excel 2003 Pivot Chart fields in Excel 2007 | Charts and Charting in Excel | |||
Weird problem with Excel 2000...Worksheets disappearing in a shared Excel file | Excel Discussion (Misc queries) | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
EXCEL FORMAT PROBLEM WHEN SENDING EXCEL SHEET AS MESSAGE BODY IN . | Excel Discussion (Misc queries) |