| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting data in a master sheet | Excel Worksheet Functions | |||
| Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Linear Mode
