Hello,
I need to provide Validation and enable formula support for few columns in the excel sheet. Sample data in a excel col1 col2 col3 6 apple 5 1> When user types in say col2, I need to automatically update the col3 with the length of the data that will be entered in col2. eg: col2= apple then col4= 5 2> Also I need to restrict the users to enter data in col2 of length less than or equal to that of number specified in col1 and therby prompt the user that he cannot enter more data in a comment box. Please guide me to achieve this. Thanks Mamatha
