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. for one month
spsn1 27 $2,700 $100
spsn2 15 $3,000 $200
needs to sort / print as:
ladder by volume
spsn1 27
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
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. for one month
spsn1 27 $2,700 $100
spsn2 15 $3,000 $200
needs to sort / print as:
ladder by volume
spsn1 27
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