Spreadsheet: 42864d1241508264-inserting-and-removing-select-rows-rows
Sheet: Gear

Category | Item | Weight (g) | Problem 1 | What I want is an option off to the side to delete specific categories from this worksheet completely.  For example, when YES is selected next to 'Backpacks - Frameless' in H24, rows 12:19 would then be  deleted. |  |  |  |  | YES
 |  |  |  |  |  |  |  |  | NO
Backpacks - Accessories | Arc'Teryx Pack Cover | 150.25
Backpacks - Accessories | Arc'Teryx Accessory Pocket
Backpacks - Accessories | Arc'Teryx Axe Keeper |  |  | Also, what I want is for the Categories to automatically Delete themselves if no items remain in them.  Example: Row 29, [NAME], I have just deleted the last remaining item in this category. I would like my worksheet to recognize there are (0) items in this category and remove the rows for me. Rows 29:32.
Backpacks - Accessories | Osprey Packs Backpack Raincover - Large | 200
Backpacks - Accessories | [NAME] with Dongle | 158.7
Backpacks - Accessories | Osprey Airporter LZ Pack Duffel (x2) | 368.54
6 | Subtotal
 |  |  |  | If only the first option is possible this is fine.  Would be nice to have both though. =]
Backpacks - Frameless | Arc'Teryx Arro 22L | 1110.16 | Problem 2 | I want to insert Category rows into there alphabetically correct location down the worksheet when a visibility option is triggered. Example: Changing J29 to YES would insert the Category (including the 3 rows below it) onto the worksheet between [NAME] and Bear Protection. (In effect, inserting my example rows 65:68 into its proper place)
Backpacks - Frameless | [NAME] 21L | 1140.21
Backpacks - Frameless | [NAME] | 1000.17
Backpacks - Frameless | Dynafit RC20 Race | 430.06
4 | Subtotal
Backpacks - Internal Frame | Arc'Teryx Bora 80L | 3231.84
Backpacks - Internal Frame | [NAME] | 2239.61 |  |  |  |  | Remove | Visible | Visible
Backpacks - Internal Frame | Arc'Teryx Naos 55L | 2126.21 |  |  |  | Backpacks - Accessories | NO | NO | YES
Backpacks - Internal Frame | [NAME] 75 + 20L | 2749.9 |  |  |  | Backpacks - Fameless | YES | YES | YES
Backpacks - Internal Frame | Osprey Crescent 110L | 3401.94 |  |  |  | Backpacks - Internal Frame | NO | YES | YES
 |  |  |  |  |  | [NAME] | NO | YES | YES
5 | Subtotal |  |  |  |  | [NAME] Sacks | NO | YES | YES
 |  |  |  |  |  | [NAME] Sacks | NO | YES | YES
 |  |  |  |  |  | Batteries | NO | NO | NO
 |  |  |  |  |  | Bear Protection | NO | YES | YES
4 | Subtotal
[NAME] Sacks | MSR Packshower | 581.6
[NAME] Sacks | Sea to Summit Ultra-Sil - 1L - 6 x 9 - Green | 20
[NAME] Sacks | Sea to Summit Ultra-Sil - 8L - 6.5 x 18 - Blue | 30
[NAME] Sacks | Sea to Summit Ultra-Sil - 13L - 8.5 x 21 - Green | 40
[NAME] Sacks | Sea to Summit Ultra-Sil - 20L - 10 x 24 - Blue | 50
5 | Subtotal
[NAME] Sacks | REI [NAME] x 16.5
[NAME] Sacks | Cactus Creek ProLite 3 - Short | 22.1126218622191
[NAME] Sacks | Therm-a-Rest ProLite 3 - Short | 21.26213640597991
[NAME] Sacks | Therm-a-Rest ProLite 4 - Reg | 25.51456368717588
4 | Subtotal
Bear Protection | Ursack S29 Bear Resistant Food Bag | 167.2621397270419
1 | Subtotal
 |  |  |  | <<<< NOT ACTUALLY ON THE WORKSHEET
Batteries | INSERT NEW ITEM HERE |  |  | <<<<JUST THERE FOR EXAMPLE OF WHAT'S TO BE INSERTED
1 | Subtotal