I have make the record as the following
if the acc no. same, then i use"-" instead of the same payee and not
input the total amount, until the last one. then i would like to know
how can i have the reust just have the filed Acc no. , Payee and total
amount
"5687 WW $400"

-input fomat::
Acc no. Payee Dept Amount Total Amout
152 ABC HR $100.00 $100.00
124 AA Account $500.00 $500.00
5687 WW Admin $100.00 -
5687 - IT $100.00 -
5687 - HR $200.00 $400.00
4153 ABC IT $500.00 $500.00


--
kilianli
------------------------------------------------------------------------
kilianli's Profile: http://www.excelforum.com/member.php...o&userid=32328
View this thread: http://www.excelforum.com/showthread...hreadid=521294