URGENT HELP NEEDED!!! AUTOMATING PICKING OUT ROWS THAT HAVE SPECIFIC CELLS MATCHING A VALUE AND COPY
Posted by DANIEL CREMIN on February 17, 2001 5:53 AM
My problem is that i need to build a marks and grades system that will allow for students who outpreform on at least 2 of the 6 test to be displayed on another worksheet. The way i have deisgned the marks and grades system is one where each student gets a predicted level (scorelike 4.5 or 5.6. They then take tests where they get marks which are automatically worked out as percentages which are then looked up against a list of Level scorces so that a level for that test can be worked out. I have made a series of cells along each row that work out the differnece between the Level score for the test and the Predicted Level score. I need a macro or some form of automated procedure that will somehow copy entire rows, that have entries in at least 2 of the Level Score varience fields which are greater than 1.0, into another worksheet.