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.

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

See one response to your later post here
and in your multi-post in .misc
(Pl do not multi-post .. )
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kt" wrote in message
...
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.