ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Limit data entry in range of cells (https://www.excelbanter.com/excel-worksheet-functions/234825-limit-data-entry-range-cells.html)

JStiehl

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.

swastik

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.


JStiehl

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