Hi
Below data is a result of sub-total function. Is there anyway I can delete
all the detail rows associated with each total and show only the data as
shown below? when I try to copy and paste, all the detail rows show up on the
worksheet. I want to show only the sub-totals (totals). There are about 300+
rows which I want to delete without deleting sub-totals.
thank you


Sender CC Hours Amount-B
1160016 Total 153.50 $9,410.02
1160018 Total 2,835.75 $156,925.78
1160020 Total 311.00 $11,510.42
1160021 Total 136.00 $7,792.80
1160026 Total 533.00 $21,479.99
1160027 Total 384.00 $25,361.06
1160029 Total 46.00 $3,034.16
1160032 Total 43.50 $3,291.21
1160035 Total 28.00 $1,986.18
1160068 Total 76.00 $4,673.15
1160076 Total 273.00 $17,753.52
1160077 Total 222.50 $13,648.69
1160080 Total 119.00 $6,881.42
1160081 Total 158.00 $9,116.12
1160090 Total 14.50 $987.27
1160095 Total 393.00 $25,474.11
1160102 Total 42.00 $2,476.74
1300034 Total 446.00 $16,633.76
1300035 Total 130.00 $6,134.20
1400008 Total 296.50 $14,296.78