triple sorting and twice sum

[nowfal]

i have a worksheet in which i wanted first date wise sorting and secon
P(purchase) sorting third- s(sale) sorting and finally each of the FC
items sum(total) to create debit and credit voucher.
can anybody help in this regard. And i would like to have these sortin
in a new sheet, not in the same sheet.
below a sample of my work sheet.

DATE P/S FCY QNTY RATE LCY
16/07/04
16/07/04 P AED 15000 0.1048 1572.000
16/07/04 P AED 1400 0.1045 146.300
16/07/04 S AED 1900 0.105 199.500
16/07/04 P SAR 1380 0.102 140.800
16/07/04 S USD 840 0.3865 324.700
16/07/04 P USD 410 0.384 157.450
15/07/04 S AED 20000 0.10495 2099.000
15/07/04 P AED 1730 0.1045 180.800
15/07/04 S USD 400 0.3865 154.600

thanks in advance
nowfa

 

[Debra Dalgleish]

You could build a pivot table from the data, with Date, P/S and FCY in
the row area, and LCY in the data area.

There are instructions and links for pivot tables on Jon Peltier's site:

http://peltiertech.com/Excel/Pivots/pivotstart.htm