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
Shital
Bookmarks