Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Restrict input if amount is exceeded
I'm using a checkbook style worksheet for a budget. I enter the total
budgeted amount in a single cell. As invoices come in, the amount is entered in one column and then the adjusted total appears next to it. (All very simple and straight forward). I would like to be able to restrict input once the budgeted amount has been reached, i.e. if the budget is $500, my running total is at $450, I receive an invoice for $60, if I try to enter $60 the cell refuses the amount. BUT, I would like to make this even more complicated by allowing the input if a code (or some such animal) is entered. Does this even sound possible? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input Form vba help | Excel Discussion (Misc queries) | |||
How do I calculate Amount of Sales Tax from Total Amount? | Excel Worksheet Functions | |||
In MS Excel, after you input an USD amount, an option for automat. | Excel Worksheet Functions | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
Conditional Format With SUMIF | Excel Worksheet Functions |