Edit=Copy
Edit=Paste Special, then Values

this replaces the formulas with hard coded values.


Many thanks for the quick reply.

I thought about that, but then I was thinking that there would come a
time when that student would need to be deleted from the "overall" list
also. At that time, I would need the formulas to be there for future
students. I guess I could just leave the students on the "overall"
sheet if I had to, but then there would be "sorting" issues once my
list got excessively long.