Dear Experts,
In the attached table, i need to make data validation using macros. Fonts in RED color are the sum of rows and columns.
Requirement: whenever the inout is given in that particualr column or row the sume should not exceed the corresponding value in both rows and columns. If it exceeds it should give error.
I tried using data validation but not successful.
It should be dynamic enough to handle the addition of rows and columns.
Attached is the sample file.
Thanks for your help in advance.
Dee...
In the attached table, i need to make data validation using macros. Fonts in RED color are the sum of rows and columns.
Requirement: whenever the inout is given in that particualr column or row the sume should not exceed the corresponding value in both rows and columns. If it exceeds it should give error.
I tried using data validation but not successful.
It should be dynamic enough to handle the addition of rows and columns.
Attached is the sample file.
Thanks for your help in advance.
Dee...