I would like that once i write the bill book with the expiration date of an invoice, the same value gets filled in the next sheet in a financial plan, that exact day.
Example:
sheet1 (bill book)
cell a1: invoice #1
cell b1: client #1
cell c1: $150
cell d1: 01/01/2010 (this is the invoice date)
cell e1: 30/1/2010 (this is the expiration day)
sheet2 (financial plan)
cell a1: january 1
cell b1: $0 (bank balance)
...
cell a31: january 31st
cell b31: $150
If it is possible, I would like the cell b31 getting filled as soon as I create the cell ei of the previous sheet.
Hopefully i was able to explain myself correctly.
Any help would be greatly appreciated.
Carlo
Bookmarks