I have 4 columns of data, I need to sort it so when the end user gets it,
they donot need to sort it.

example:

Random Hour Skill Location Sort Loc Sort Hour Sort Skill
1 12 8 2
2 16 12 14
3 12 4 12
4 14 6 16
5 10 10 20

The data is randomize by a formula, but I need to sort it into another
column, the sort needs to be by Location, then by Hour then Skill. How can i
do this? I want to sort this totally into another set of columns labeled Sort
Loc, Hour & Skill.

Need help

Thank you

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

If the data is randomized then how will you maintain the sort order? As soon
as user runs any calculation random data will be refreshed...

"Six Sigma Blackbelt" wrote:

I have 4 columns of data, I need to sort it so when the end user gets it,
they donot need to sort it.

example:

Random Hour Skill Location Sort Loc Sort Hour Sort Skill
1 12 8 2
2 16 12 14
3 12 4 12
4 14 6 16
5 10 10 20

The data is randomize by a formula, but I need to sort it into another
column, the sort needs to be by Location, then by Hour then Skill. How can i
do this? I want to sort this totally into another set of columns labeled Sort
Loc, Hour & Skill.

Need help

Thank you

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc