Sort Without User Input

G

guilbj2

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

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

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

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

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