Try using an IF statement in your DR and CR columns. Something similar to:
=if(c5="DR",d5,0)
=if(c5="CR",d5,0)
--
Damon Longworth
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com
"****al shah" wrote in message
...
Hi to all
I have data field for bank entry like
Tran Date, Description,Dr-Cr,Amt,Balance.
Now How can i transfer amt of Dr. and Cr. into next column.
What i want is if there is Dr. amt it should goto DR. Coulmn and if Cr.
amt
it should goto Cr. cloumn.
I have inserted Dr. and Cr. column into worksheet.
Like
Tran Date, Description, Dr-Cr, Amt, Dr, Cr,Balance.
So if in Dr-Cr column if Dr. than that amount should move into Dr. Column
same for Cr amt also.
Any help.
Thanks
****al