Hi, I have a master worksheet containing test cases and I want to be able to select the test cases to be copied to a new worksheet for testing a specific area of functionality. The test cases are grouped by functionality in a hierarchical manner (example below) and I want to be able to select the parent checkboxes, which would cause all of the children to be automatically selected/deselected.

1.0 Inventory [checkbox]
1.1 Inventory Adjustments [checkbox]
test case [checkbox]
test case [checkbox]
1.2 Inventory Center [checkbox]
test case [checkbox]
test case [checkbox]
1.3 Invoice Entry [checkbox]
test case [checkbox]

Any row with a selected checkbox would then be automatically copied and populated into a new worksheet.

Also is there an easy way so that if new rows are added into the master worksheet that they would automatically have a checkbox with the same functionality as described above.

I have just started playing around with Macro's and would appreciate any guidance.

Thanks!