Is there a way that I can sort data on one sheet and have the formulas
that link to this data automatically update?

Sheet 1
___A___B___
1__82_____
2__40_____
3__77_____

Sheet 2
________A__________B____________C_______
1__=Sheet1!A1___=Sheet1!A2___=Sheet1!A3__


Sort Column A, Sheet 1 Ascending
1__40
2__77
3__82

Sheet 2 Updates
1__=Sheet1!A2___=Sheet1!A3___=Sheet1!A1


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=571405