Using check boxes to add and populate new columns to table

satheo

New Member
Joined
Jun 10, 2014
Messages
31
I have a table with a column of form control check boxes on each row that I want a user to be able to select from and then have those selected rows add some of that data to new columns in another table.

So example Table 1:
A1A2A3Check Box 1
B1B2B3Check Box 2
C1C2C3Check Box 3
D1D2D3Check Box 4

Let's say I check boxes 1 and 3, so I'd then want to add 2 columns to Table 2, like so:

Title text<added column><added column>Summary formula
Title textValue from A1Value from C1Summary formula
Title textValue from A3Value from C3Summary formula
Title textdynamic user-adjusted fielddynamic user-adjusted fieldSummary formula
Title textformula referencing dynamic fieldformula referencing dynamic fieldSummary formula

Been trying to salvage together some code but not having any success, essentially I'm trying to cycle through each check box, if true then add column to Table 2 and populate as indicated above. The check boxes are labeled sequentially 1-53 and I have a set number of them.
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Forum statistics

Threads
1,144,629
Messages
5,725,384
Members
422,622
Latest member
Paranthem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top