Forum Discussion
Help for auto returning a value between worksheets...confused teacher
Hello Kelly,
Try this. I took the liberty of feeding the names from sheet one to all of the other sheets, so you only have to add the names once. I did this because it directly references back to the cells on the other sheets, it doesn't care if the name to the left is the same. It doesn't allow for adding someone mid-year. You would just add them to the first empty slot on the first sheet, and track from there. It's fairly simple, but potentially easy to break as well. Each sheet is protected, with the cells with formulas locked, but there is no password, so you can just go to the Review tab, and click unprotect sheet. Let me know if it will work for you.
Hello Kelly,
Try this. I took the liberty of feeding the names from sheet one to all of the other sheets, so you only have to add the names once. I did this because it directly references back to the cells on the other sheets, it doesn't care if the name to the left is the same. It doesn't allow for adding someone mid-year. You would just add them to the first empty slot on the first sheet, and track from there. It's fairly simple, but potentially easy to break as well. Each sheet is protected, with the cells with formulas locked, but there is no password, so you can just go to the Review tab, and click unprotect sheet. Let me know if it will work for you.
One more query I'd love to fix if possible....for honor roll/banner roll.....honor means As and Bs, banner means all As. So, if a student has honor roll three times, and banner roll once (or any combination), as long as they AT LEAST make honor roll all year, they will qualify for honor roll.
So, if a kid has x in three honor roll columns, and one banner roll, the last sheet won't show a YES in the honor roll section, but it should. So how can we auto-calculate that? Is it possible?
Kelly,
This should work for you. If there is an x in either Honor roll or Banner roll, on all 4 sheets, the overall sheet displays Yes for Honor roll. If they achieve Banner roll on all 4 sheets, Honor roll and Banner roll will both display Yes
- That is PERFECT! you just saved about 100 teachers a boatload of time for this year! Thank you soooo very much for doing this for us!
I must learn how to be as awesome as you are at Excel!!!