Hi kbuilta,

This sounds like a really complex estimate/order form. I have a similar
add-in project that has (currently) 17 product sheets (templates). Each one
has multiple configuration possibilities, so a salesperson can just enter a
quantity for each feature and formulas populate the necessary cells. These
sheets can contain hundreds of rows of line item info (specs), but the user
can hide (filter) any rows that don't have input. The sheets are protected,
with all input cells unlocked so the user navigates a logical path using the
Tab or Arrow keys. Conditional Formatting is used throughout.

It's incredibly easier than having all those controls on a sheet. In fact,
there's no controls at all (no macros), so the quotes can be sent anywhere
because they can be created in any workbook. It was designed this way so the
finished form could be emailed easily without firewall hassles. Everything
needed to process each sheet is in the add-in.

The nice thing about this design is there's no redundancy. Every feature for
each product is listed only once, in the section appropriate for its
application. Additional info is provided using cell comments where
appropriate. Updating is done by looping through each sheet by item number,
and looking it up on a query sheet to get description or pricing changes.

I originally had controls on the sheets, but I couldn't stand having them
there. I wanted a clean UI, and I couldn't make sense of the maintenance
required to manage them all (like you are facing now).

Food for thought! HTH
Regards,
Garry