Check-box value in formula - Dates - Board Archive - MrExcel Publishing
Check-box value in formula
Posted by Dave C on August 24, 2001 4:45 AM
I have 13 columns (labled with workers' initials)with 62 rows. The rows contain check-boxes. I would like to output the value of all the checked columns to a second worksheet, using the columns label. That is, if the check-box is checked under the column heading of MH and DC, but not CL then on the second worksheet I would like it to display something similar to "MH, DC". Note that "CL" would not be listed because it was unchecked. It would also be feasible to have all 13 checked, listing all of the 13 initials (labels). Is this possible? If you are totally confused, email me and I can send you a sample worksheet. Thanks in advance!
Posted by Robb on August 24, 2001 5:52 AM
Check-box value in formula - Dates - Board Archive - MrExcel Publishing
Check-box value in formula
Posted by Dave C on August 24, 2001 4:45 AM
I have 13 columns (labled with workers' initials)with 62 rows. The rows contain check-boxes. I would like to output the value of all the checked columns to a second worksheet, using the columns label. That is, if the check-box is checked under the column heading of MH 
and DC, but not CL then on the second worksheet I would like it to display something similar to "MH, DC". Note that "CL" would not be listed because it was unchecked. It would also be feasible to have all 13 checked, listing all of the 13 initials (labels). Is this possible? If you are totally confused, email me and I can send you a sample worksheet. Thanks in advance!
Posted by Robb on August 24, 2001 5:52 AM