I have a list of data in 4 columns (A:D) that I want to sort in
ascending order using a numerical value in column B. While it's simple
to do so with the sort command, I'm trying to find a way without doing
so. I'll clarify a little of the overall objective to explain why.

I'm basically taking a report generated externally and trying to create
a template for some non technical co-workers. The level of help I can
expect is for them to basically copy the ore-generated report into cell
A1 of a worksheet and click on a different sheet to see a finished
product.

I've used vlookup and some formulas to modify the data as needed, but
am stuck at finding a way to sort the final list that does not involve
the user manually doing so. Any ideas?


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=541335