This might be a tough one, and I think you'd need to be an excel expert to figure it out. But I bet someone can! A bunch of teachers have a Google doc that we're sharing to show each other when we call parents. We each have our own worksheets within the same workbook. We would like to be able to have an additional sheet that has an alphabetical list of students that feeds from the other sheets. So every time a teacher calls a student's home, it is automatically loaded into the proper place on the sheet I mentioned. I know how to put data in the same spot on two sheets, with the = and then copying the cell number, but not what I mentioned above. Any ideas?? Thanks!
So your issue is the sorting of the alphabetical sheet after a teacher indicates on their own sheet that a call has been made? How are the current sheets set up? How are you recording the contacts on the teacher sheets?