Basic Sort Question

[hudsonhacker]

I am new here, and my excel skills are basic, so please bear with me.

I am doing an analysis that outputs a range that is 2 columns wide by 4 rows, let's call them:

Name Seed
Team 1 9
Team 4 3
Team 6 8
Team 8 1

I then need to sort the above range based on the seed value, but how do I do that if the analysis keeps providing different info to sort?

Basically, I now need to populate another range based on sorting the above range, so my new range would look like:

Name Seed
Team 8 1
Team 4 3
Team 6 8
Team 1 9

Simple to do, but how do I do it so that every time I change my input data, it resorts my output data?

Never used a macro or VBA. Guess I would need to write a fairly long IF Statement?????

Please keep it simple, I have not used complex excel in a LOOOOONNNNNNGGGG time.


Thanks

 

[njimack]

Excel Workbook
	A	B
1	Name	Seed
2	Team 8	1
3	Team 4	3
4	Team 6	8
5	Team 1	9
Sorted

Excel Workbook
	A	B
1	Name	Seed
2	Team 1	9
3	Team 4	3
4	Team 6	8
5	Team 8	1
Data