Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
I have a workbook with multiple worksheets. On worksheet 1 I have 10 check
boxes (Cells A1 to A10) that, when checked, links the data in Worksheet 1 (Cells B1 to B10) to Cells B1 to B10 on Worksheet 2. Cell B1 on Worsheet 1 is linked to Cell B2 on Worksheet 2 and so on. The formula I used (that someone in the Excel Discussion Group gave me) is =IF(Worksheet1!A1<TRUE,"",IF(Worksheet1!B1="","", Worksheet!B1)). I put this formula in cell B1 or Worksheet 2 and it works fine. My question is, is there any way I can set up Worksheet 2 so that if any of the 10 checkboxes on Worksheet 1 are checked (let's say three of them), the data that corresponds with those checkboxes will show up in the first three cells on Worksheet 2? Put another way, If I have 100 checkboxes on Worksheet 1 (with specific data linked to each one) and I only check 3 of them, is there anyway to make the data linked to those 3 checkboxes show up in the the first 3 cells (A1, A2, A3) of Worksheet 2? If so, how would I do that. Any assistance would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check Boxes
Check your other post and please don't double post
"Joe" wrote: I have a workbook with multiple worksheets. On worksheet 1 I have 10 check boxes (Cells A1 to A10) that, when checked, links the data in Worksheet 1 (Cells B1 to B10) to Cells B1 to B10 on Worksheet 2. Cell B1 on Worsheet 1 is linked to Cell B2 on Worksheet 2 and so on. The formula I used (that someone in the Excel Discussion Group gave me) is =IF(Worksheet1!A1<TRUE,"",IF(Worksheet1!B1="","", Worksheet!B1)). I put this formula in cell B1 or Worksheet 2 and it works fine. My question is, is there any way I can set up Worksheet 2 so that if any of the 10 checkboxes on Worksheet 1 are checked (let's say three of them), the data that corresponds with those checkboxes will show up in the first three cells on Worksheet 2? Put another way, If I have 100 checkboxes on Worksheet 1 (with specific data linked to each one) and I only check 3 of them, is there anyway to make the data linked to those 3 checkboxes show up in the the first 3 cells (A1, A2, A3) of Worksheet 2? If so, how would I do that. Any assistance would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check boxes | Excel Discussion (Misc queries) | |||
Check Boxes | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do i create a value for check boxes or option boxes | Excel Discussion (Misc queries) |