maytey
09-05-2008, 09:56 AM
Hi,
I am currently preparing my company's budget and would require a macro for my budget templates. I will actually need a macro to check a sum of ranges to make sure it is not above a certain amount.
For example
Row B12 - Total Staff Cost - Maximum cap = $50K
Row B15 - Total G&A Cost - Maximum cap = $10K
Is there a way to stop the user from saving the file if the amount they have keyed in the summary file exceeds the budget guideline given?
Thanks.. Your help will be greatly appreciated!
I am currently preparing my company's budget and would require a macro for my budget templates. I will actually need a macro to check a sum of ranges to make sure it is not above a certain amount.
For example
Row B12 - Total Staff Cost - Maximum cap = $50K
Row B15 - Total G&A Cost - Maximum cap = $10K
Is there a way to stop the user from saving the file if the amount they have keyed in the summary file exceeds the budget guideline given?
Thanks.. Your help will be greatly appreciated!