Daniel Cremin
Board Regular
- Joined
- Feb 23, 2002
- Messages
- 64
Hi please please please help me if you can, i will be so grateful. I have a marks and grades system where each time a new student is added using a pre-excel 97 dialog form a special "master-row" called "specialrow" gets copied (in contains all the formulaes) and then inserted on top of the special row - the data entered on the form is then pasted into cells on this new row. The system is designed to cater for up to 30-32 students a year but it can be less if that is the case - i need a macro that at the end of the year can "clean down" the last years system so to speak by deleting all the inserted student rows so that the "special row" row of cells is just below the row header (row 2) on the worksheet called processing and storage - please note that there is also cells below the special row and that the first two rows of the workbook are Titles/ Headers that cant be deleted. Is there anyway to "reset" the system for new students to be entered in the next academic year from scratch? Im sure theres a way to delete all rows between the second row of a worksheet and the "special row" which could be any number of rows (but never more than 32 at max down from the header).
Thanks so much in advance - im having panic attacks over this so any help would be greatly appreciated.
Thanks so much in advance - im having panic attacks over this so any help would be greatly appreciated.