Hi,

Lets say I have a list of Sales Reps in column A, Turnover Figures in
B, Cost Value in C, Margin in D etc etc.......

I need to sort them, sometimes by Rep, some times by Margin ascending,
sometimes by Turnover Ascending etc etc.

Are there any formulas I can use to do this instead of using the sort
function EVERY TIME

Cheers Guys


--
sammy2x
------------------------------------------------------------------------
sammy2x's Profile: http://www.excelforum.com/member.php...o&userid=29674
View this thread: http://www.excelforum.com/showthread...hreadid=512169