Hello. I am creating an Excel workbook for scheduling and billing tutored students. One sheet contains the schedule, another the students and their rate, and the last the teachers and their rate. The rates won't be visible in the schedule sheet, only the student and teacher names. Therefore, I need to assign the value of the rate to the name as though the name were a variable. If the values were updated they would need to update on the schedule sheet too, where the final calculating happens. This is complicated by the fact that students and teachers can be moved to any time slot.

I looked at "Linked Objects" but saw nothing about assigning values to a variable name. If it is possible, how would I do it?

Thanks!