Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sorting without affecting links
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 without affecting links
One way is to use VLOOKUP in Sheet2 for the Fees
Assume in Sheet1, names are in col A, Fees in col B data from row2 down In Sheet2, names are listed in A2 down, Fees to be extracted in B2 down Put in B2: =IF(A2="","",VLOOKUP(A2,Sheet1!A:B,2,0)) Copy B2 down as far as required -- 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 | |||
Deleting links to other spreadsheets | Excel Worksheet Functions | |||
Update links prompt not wanted | Excel Discussion (Misc queries) | |||
Maintaing formula links when sorting | Excel Discussion (Misc queries) | |||
sorting links | Links and Linking in Excel | |||
can't update links...can't find links | Excel Discussion (Misc queries) |