Limit data entry in range of cells
I have 6 columns with headings that repeat in a row. Users should make a
check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
Limit data entry in range of cells
Are you using clickbox?
"JStiehl" wrote: I have 6 columns with headings that repeat in a row. Users should make a check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
Limit data entry in range of cells
No, I am not using clickbox.
"swastik" wrote: Are you using clickbox? "JStiehl" wrote: I have 6 columns with headings that repeat in a row. Users should make a check under a maximum of 3 out of the 6 heading choices--is there a way to restrict them to only select 3 or less? Additionally, the data they can select needs to be limited. For example, they may place checks under 2 snacks and 1 meal, but not 3 meals or 3 snacks. Thanks for your help. |
All times are GMT +1. The time now is 04:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com