sorting data to new area on sheet

I

Ian

Hello
Have a data sheet which accumulates by mth, sales staff volume, gross profit
and average gross - one row per salespsn, three columns (vol,gross,ave) per
mth (and a cumulative group)
I want to produce a report (which could be on the same sheet, within mth
group), which separates volume, gross profit and average, all sorted by rank
for that period.
e.g. one month data
spsn1 27 $2,700 $100 ... more columns for other months
spsn2 15 $3,000 $200

needs to sort / print as:
ladder by volume
spsn1 27 ... more columns for other months
spsn2 15

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

ladder by average
spsn2 $200
spsn1 $100

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top