E
edrachel
Hi, I have not done anything with check boxes before, so I am reall
new at this. I am trying to do a sheet that will have check boxes tha
when checked will return a number from another sheet. When the box i
not checked, it should return a "0". If I just use a check column,
don't have any problems with the formula to pull the number from th
other sheet when you put an "x" in the column but I would like to us
check boxes or buttons. I will be sharing this will peers and woul
like to just make it a simple click. I have attached a copy of what
have completed. Only the first two lines are done but it should giv
you an idea of what I am trying to do. Any help will be appreciated.
Thanks
Attachment filename: quality analysis.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64640
new at this. I am trying to do a sheet that will have check boxes tha
when checked will return a number from another sheet. When the box i
not checked, it should return a "0". If I just use a check column,
don't have any problems with the formula to pull the number from th
other sheet when you put an "x" in the column but I would like to us
check boxes or buttons. I will be sharing this will peers and woul
like to just make it a simple click. I have attached a copy of what
have completed. Only the first two lines are done but it should giv
you an idea of what I am trying to do. Any help will be appreciated.
Thanks
Attachment filename: quality analysis.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=64640