View Single Post
  #1   Report Post  
Kt
 
Posts: n/a
Default 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.