Locking column entries to an adjacent linked column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
If it were up to me, I'd put all the information on a single sheet and
sort that. If you need separate Dues and Fees tables for reports or
whatnow, refer from those sheets to the main sheet for the needed
information.

For instance, if on the Master Roster sheet you have your Names in
column A and Dues in column H, then your Dues sheet column B could
refer to the Master Roster sheet column H. In Dues!B1 you would have:

='Master Roster'!H1

and copy that down as far as you need.
 
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

VBA - retrieve data on last create named range from previous inserted named range 0
Not sure what I need other than help 4
Tie additional cells to cell automatically updated 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
How do I find duplicate entries in a column in an Excel worksheet? 19
Linked cells between worksheets and sorting 2
derive data from masterlist to another worksheet in same workbook 2

Back
Top