View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steeljaw
 
Posts: n/a
Default Locking column entries to an adjacent linked column

Workbook w/3 worksheets. Master Roster, Annual Dues, and Dance Fees. The
Name column of Master is linked to the Name column of the other 2 worksheets.
The Dues and Fees worksheets have a Dues and Fees column adjacent to the
Name column - entries there are tied to that name. When entering a new name
on the Master sheet, sorting alphabetically causes the Dues and Fees columns
to be off by one row below the new name after the sort. Is there a way to
lock the Dues and Fees columns to the Name column entry so this does not
happen? Thanks from a newbie!