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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
See one response to your later post here
and in your multi-post in .misc
(Pl do not multi-post .. )
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

link between sheets get messed when master sheet is sorted 1
sorting without affecting links 1
Vlookup and Indirect 0
Issues with Linking Data in Various Tabs within a workbook? 5
Dependent drop down dynamic range formula, off sheet. 7
Update cell value based on name and specific date 1
copying text across sheets 1
How Can i Link With one sheet to another sheet in Row to Column 1

Back
Top