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

The easiest way I know of is to write a sub and link that to a button (Ctrl +
Shift + C) and tell them to press that button any time they need to sorted.
If thats alright and you don't know how to make a sub then post an example of
your spreadsheet and how youd like the order. Perhaps then we could help
further. Someone else may know of a better sollution though. I'm very new
to Excel and VBA.
"guilbj2" wrote:


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

Here's one play to achieve this, using non-array formulas

Assume source data is in sheet: X, within cols A to D,
data from row1 down to a max expected row100

In another sheet: Y,

Put in A1:
=IF(ISERROR(SMALL($E:$E,ROW(A1))),"",
INDEX(X!A:A,MATCH(SMALL($E:$E,ROW(A1)),$E:$E,0)))
Copy A1 to D1

Put in E1: =IF(X!B1="","",X!B1+ROW()/10^10)

Select A1:E1, fill down to E100

Y auto-returns an ascending sort of what's in X, sorted by X's col B
with all results neatly bunched at the top
(Hide away the criteria col E, if desired)

Then, to refresh the source data in X,
just select and clear with the Delete key,
(but do not delete cols, as this will foul up the formulas)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"guilbj2" wrote:

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