Sorting a Simple table

[paulio]

Ok what I want to do is this. I have a list of employee's names and i
the next cell I would have the amount of sales they have done that day
Easy enough to do but I want a list like the one shown below:

Code
-------------------

Rank Name Sales Rank Name Sales
1. 6.
2. 7.
3. 8.
4. 9.
5. 10.

-------------------

I'm having problems formatting the sort so that it would go ove
multiple columns. I would want to be able to change the sales for
particular person and then activate a macro and it would reorder th
data for me.

Any help would be appreciated.
Pau

 

[Bernard Liengme]

If I read question correctly:
Put the data in a single table
Sort
Use Sheet2 with formulas like =Sheet!A1 etc to design the report

best wishes