Sort Without User Input

[guilbj2]

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?

[Abode]

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
>
>

[Max]

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
>
>