Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am redesigning my budget form to incorporate two sheets, one is a detailed
sheet by nominal code in cost centre for budgets over the next 5 years by month. The other is a supplier listing with annual budgets against them. I want to prevent users saving or closing-down the sheet unless the total of the suppliers budgets = total of the nominal budgets for the year. Simply unless cell K9 is 0.00 then prevent closing of the form. Please help as this will save me LOADS of time when it comes to checking these things. Many thanks in advance Adam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Condition IF | Excel Discussion (Misc queries) | |||
Add condition to formula | Excel Worksheet Functions | |||
External reference as a condition | Excel Worksheet Functions |