ExcelBanter - sorting master sheet messes up cells in other sheets linked to it

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sorting master sheet messes up cells in other sheets linked to it (https://www.excelbanter.com/excel-worksheet-functions/52897-sorting-master-sheet-messes-up-cells-other-sheets-linked.html)

sorting master sheet messes up cells in other sheets linked to it

Sheet 1 complete list of names all pupils and fees per month
Sheet 2/sheet per instructor - list of pupils per instructor with names and
fees linked from sheet 1
Problem. If we add new names to sheet 1 then sort it alphabetically the rows
change so sheets 2s values get messed up.

All times are GMT +1. The time now is 05:28 PM.