title: Using a checkboxes to create a data set to be copied in excel
body: <p>I'm building a sheet to optimise task completion. I've got four work sheets in total.</p>
  <p>I'm aware excel has a &quot;scenario&quot; function, I am not referring to this when I mention it below.</p>
  <ol>
  <li>&quot;Input&quot; - a simple checkbox table the user can select which tasks will be completed in &quot;Scenario&quot;. When a button is pressed the scenario is saved as &quot;Scenario 1&quot; and the completion score is calculated and put into the sheet named &quot;Output&quot;</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/vzKHE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vzKHE.png" alt="enter image description here" /></a></p>
  <ol start="2">
  <li>&quot;Table&quot; - Backend matrix that I'm using the calculate the completion score to copy over to each scenario. I'm comfortable with the code needed to copy the updated completion score to the sheet named &quot;Calc Sheet&quot;.</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/rP1i6.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rP1i6.png" alt="enter image description here" /></a></p>
  <ol start="3">
  <li>&quot;Calc Sheet&quot; - Backend calculation table, that will have the &quot;Value to copy&quot; pasted/overwritten  in the &quot;Scenario Uplift&quot; Column. The total score for the aspect is calculated here and then copied to a running total.</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/WHqbu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/WHqbu.png" alt="enter image description here" /></a></p>
  <ol start="4">
  <li>&quot;Output&quot; - a dashboard that ideally shows the components of each saved &quot;scenario&quot; as well as a graph tracking the increasing completion score.</li>
  </ol>
  <p><a href="https://i.stack.imgur.com/jcpLp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jcpLp.png" alt="enter image description here" /></a></p>
  <p>Where I am stuck is on the following:</p>
  <p>-Pulling through the selected options/checkboxes that each scenario comprises of to the &quot;Output Sheet&quot;. I was trying to build out another row and column to the matrix on &quot;Table&quot; to turn true if there was any true within the row/column, and copy the corresponding row/column title, but this solution wouldn't hold when calculating the running total. I feel like there is some super obvious solution using the array position of the &quot;true&quot; but I'm being dense. :(</p>
  <p>-Once a ticked check box has been included in a scenario, is there a way to &quot;freeze&quot; it so it cannot be selected again.</p>
  <p>Thanks in advance.</p>