Hi
I have a table with 12 columns which is used for tracking Receipts and Payment for Individual CLient. (I have a sample file. But this forum doesnt seem to allow me to attache it to the post)
I am trying to create a automated consolidated snapshot as of current date i.e. Total Principal Receipts, Total Principal Repaid, Total Interest Accrued, Total Interest Paid and Current Balance Principal & Current Balance Interest (Accrued but unpaid)
I am struggling with following:
1) When I make a new Entry with "Principal Receipt" selection in combobox, I would like the date of this new entry to be copied in the "Interest cutoff Date" in "Column H" of previous "Principal Receipt" entry (if any). So, Interest for the older Principal Amount is stopped on that date and then the interest on the NEw total Principal Amount (Old Principal + Principal Receipt in the new entry) is started from the date of the new entry.
2) I have inserted formula in G , I and J columns. Is there a way I can clear contents of this table with a button without loosing the formulae that are there? I have created a clear button, but it also clears the formula in all columns
Can someone please help !
Cheers
V
I have a table with 12 columns which is used for tracking Receipts and Payment for Individual CLient. (I have a sample file. But this forum doesnt seem to allow me to attache it to the post)
I am trying to create a automated consolidated snapshot as of current date i.e. Total Principal Receipts, Total Principal Repaid, Total Interest Accrued, Total Interest Paid and Current Balance Principal & Current Balance Interest (Accrued but unpaid)
I am struggling with following:
1) When I make a new Entry with "Principal Receipt" selection in combobox, I would like the date of this new entry to be copied in the "Interest cutoff Date" in "Column H" of previous "Principal Receipt" entry (if any). So, Interest for the older Principal Amount is stopped on that date and then the interest on the NEw total Principal Amount (Old Principal + Principal Receipt in the new entry) is started from the date of the new entry.
2) I have inserted formula in G , I and J columns. Is there a way I can clear contents of this table with a button without loosing the formulae that are there? I have created a clear button, but it also clears the formula in all columns
Can someone please help !
Cheers
V
Last edited: