I amaze myself at what I can't figure out. Anyways .. using excel 2000
3 worksheets in this document:
master roster sheet
attendance worksheet
running total worksheet
The Master Roster sheet has key columns linked to the attendance and running totals worksheet (lastname, firsname, IDnumber, etc).
Problem:
When I add a name to the master roster and re-sort the list, the names re-sort on the Attendance and running total worksheets (as they should) but the data attached to the name does not move with the name. End result: if we sort, the names change but the data is now connected to the wrong person.
How do I stop that from happening?
Thank you. Your help in the past has been invaluable.
Bookmarks