B
Beemer
In my Excel 2007 workbook I have two sheets
The "Master Names" sheet has columns:
(A) First|(B) Last (C) First (B) Last (concatenated)
The "Selected Names" sheet contains (A) cells which link to selected (C)
First Last (concatenated) cells in the Master Names sheet.
Everything links and displays fine except when I add names to the bottom of
the Master Names sheet and then sort using (B) Last name column. When I do
this I get a 0 (zero) in the (A) First Second cells in the Selected names
sheet and other cells in this sheet have the wrong name.
Obviously I am doing something wrong but what?
Beemer
The "Master Names" sheet has columns:
(A) First|(B) Last (C) First (B) Last (concatenated)
The "Selected Names" sheet contains (A) cells which link to selected (C)
First Last (concatenated) cells in the Master Names sheet.
Everything links and displays fine except when I add names to the bottom of
the Master Names sheet and then sort using (B) Last name column. When I do
this I get a 0 (zero) in the (A) First Second cells in the Selected names
sheet and other cells in this sheet have the wrong name.
Obviously I am doing something wrong but what?
Beemer