'Automatic' sorting to printable report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi
I have a data *** 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 ***, 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 *** to dynamically update the
'print' area when entries made by month, or macro to run to generate it, or
new *** for report, or or or ????
Starting point / help greatly appreciated
Thanks, Ian


.

Quantcast