Hey, I'm in dire need of your help.
I use Excel to manage my bank and to make life easier I need the following doing (if possible)
See attached.. I have a list of my bills along with it's Due Date and if it's been paid or not (The "Paid" column has drop-down menu so I can select "Yes" or "No")
Example:
If E10 is displaying "Yes" then D10 will display £0.00
If E10 is displaying "No" then D10 will display whatever number I want it too
&
When I enter a number greater than £0, it changes the "Paid" on E10 to "No"
This way I can enter my monthly bills, and once I've paid it, I can select "Yes" and it'll automatically change the "Due Now" to £0, resulting in the total being correct for the bills I've got left to pay, and then when I enter a new amount for my bill next month, it'll change D10 back to "No" until I select "Yes" again.
Then also, if possible, once I enter a number into any of the "Due Now" columns, then it changes the "Paid" to "No"
Is there any way to do this?
Thanks in advance for your help, if you need any more information then let me know.
Bookmarks