Problem after sorting

  • Thread starter Thread starter Beemer
  • Start date Start date
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
 
Sorry, the line under the "The master names" line was incorrect. All
should read:

In my Excel 2007 workbook I have two sheets

The "Master Names" sheet has columns:

(A) First|(B) Last (C) First 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
 
| Sorry, the line under the "The master names" line was incorrect. All
| should read:
|
| In my Excel 2007 workbook I have two sheets
|
| The "Master Names" sheet has columns:
|
| (A) First|(B) Last (C) First 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
|
|
|
 
Back
Top