VBA to search a column for text matching a named range cell.
Posted by Daniel Cremin on December 12, 2001 11:11 AM
Hi Thanks for helping me whoever reads this. I have an underlying sheet called Processing with a load of student details, test marks and percentages and grades on them. i have a sheet called a Student Details Editor where a load of cells dislplay certain data (Student Name, Teacher, Test marks for the 5 tests) via INDEX functions that use the index no of a student name picked using a list box of student names from the processing page (C8:C38).I need to be able to search on the processing sheet and select the cell in the range C8:C38 that matches the named range (cell) SDEStudentName on the Student Details Editor Sheet. I probably need a Do Until statement but really am stuck and need a way to offset to the cell that matches the SDEStudentName cell on the other cell (same student name) so that if i update details on a specialised cell bwlow on the Student Details Editor i can offset and paste (i can do this bit of the VBA procdure myself).