Hi
I have a data sheet which contains in monthly groups of columns,
sales staff volume, gross profit, average gross
- one row per salesperson, three columns (vol,gross,ave) per month

I want to produce a report (which could be on the same sheet, within month
group),
which separates volume, gross profit and average, all sorted by rank for
that period.
e.g. for one month, data is:
A B C D
spsn1 27 $2,700 $100
spsn2 15 $3,000 $200
spsn3 20 $3,900 $195

needs to sort / print as:
------------------------------
ladder by volume
spsn1 27
spsn3 20
spsn2 15

ladder by gross
spsn2 $3,000
spsn3 $3,900
spsn1 $2,700

ladder by average
spsn2 $200
spsn3 $195
spsn1 $100
--------------------------------

I can't even get a start - fixed formula on sheet to dynamically update the
'print' area when entries made by month, or macro to run to generate it, or
new sheet for report, or or or ????
Starting point / help greatly appreciated
Thanks, Ian