I have a worksheet with student demographic data. Column A has name, Col
B has address, Col C has instructor, Col D has instrument, etc.
There are command buttons at the top for sorting the data, 1 for the
student name (ColA), another for sorting by the instrument etc.
The student names are Paste Linked to a second worksheet.

Problem:
When the sort is triggered from the first worksheet, the names on the
second worksheet change according to the paste link. I would all the
information on the second sheet to move with the names if any sorting
is triggered on the first worksheet. Now when a sort is triggered on
the first worksheet, the names change on the second sheet but the rest
of the columns do not change thereby making all the statistics
irrevelant.

Any formulas, VBA, or functions will help.
Thanks
gsh20


--
gsh20
------------------------------------------------------------------------
gsh20's Profile: http://www.excelforum.com/member.php...o&userid=26606
View this thread: http://www.excelforum.com/showthread...hreadid=465763