shadedlight
Member
Hello,
Looking for a solution. I have clients who prepay for treatments. I want to record their prepayment and then have the workbook update the values. In the example workbook that I have included, I created two worksheets; 'Prepaid' which lists the amount they have prepaid and 'treatment' sheet which reflects the balance they have left. Here is what I would like to accomplish, when I enter a patients name in column B the treatment amount is entered into column C, and the balance is reflected in column D. The 'prepaid' sheet would also adjust and reflect the prepaid balance. Lastly, conditional formatting applied to signify when patient has a zero balance. I've included a sample workbook. Thank you.
Looking for a solution. I have clients who prepay for treatments. I want to record their prepayment and then have the workbook update the values. In the example workbook that I have included, I created two worksheets; 'Prepaid' which lists the amount they have prepaid and 'treatment' sheet which reflects the balance they have left. Here is what I would like to accomplish, when I enter a patients name in column B the treatment amount is entered into column C, and the balance is reflected in column D. The 'prepaid' sheet would also adjust and reflect the prepaid balance. Lastly, conditional formatting applied to signify when patient has a zero balance. I've included a sample workbook. Thank you.
