Hi all
I am new in Excel and made a programme to calculate the amount for my clients
I have 100+ rows. In One column I have their prev. balance. and next each months collection in every cell. like this
Name Balance Jan 2010 Feb 2010 Mar 2010
Amit Kumar 300 0 150 50
I want to add 1500 first in Balance column. Now when I insert the value of April 2010 (say 150) balance should be substracted from that amount.
Please help
Thanks
Not sure how your sheet is set up, but I would think that you need an Opening Balance Column
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
yes it will work but then I will have 2 columns and I have to copy the closing balance column value in opening balance before adding the amount (150)
Any suggestion?
Thanks
Last edited by aijazansari; 01-01-2010 at 07:49 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks