sorting without affecting links

  • 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.
 
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
 
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 master sheet messes up cells in other sheets linked to it 1
VBA? Macro? 0
Vlookup and Indirect 0
Excell 2000 IF Statement 1
linking within a workbook and sorting 2
Not sure what I need other than help 4
Locking column entries to an adjacent linked column 1

Back
Top