im trying to create a somewhat active balance book. colum A=date(monthly); column B=income; column C=expense; column D=balance. on another sheet i have an amotization schedule(taken from the default template). i want to have my balance book reference the amortization schedule when it starts and finishes. so if my amortization schedule starts in April 2010 then on my balance sheet i want the first payment to appear in column C in the corresponding row where the date in column A matches the date of teh first payment of the amortization schedule. also with the idea that the balance book may start at different dates. A1 might equal Feb 2010 or maybe August 2011. if teh date in column A = the date of a payment in the amortization schedule, i want it to report the payment in column C of the same row.
Bookmarks