I have a range of cells Sheet1!$D$7:$D$11 that contain names that link to another range on a separate sheet - Sheet2!$E$6:$E$10. My problem is that when I change the order of the names using Shift-Drag on Sheet2!E6:E10, the order does not change in $D$7:$D$11. The references simply change to the new location on Sheet2!$E$6:$E$10. I need for the references to stay the same. In other words, $D$7 will ALWAYS link to $E$6

Thanks.

-ep