Hello all,

New here and trying to learn the Excel ropes.

Ive got a pretty good start on a pricing sheet for my small business but i need some help to get it to where we can start to use it.

In the attachment, there are two parts(a21:ad32 and a34:ad45). One requires a die(group of cells titled "Die information") and one will be cut on a table by hand(group of cells titled "table information"). There is also a group of cells titled "components".

I would like to accomplish the following:

- Create three(3) check boxes with each of the titles above(Die Information, Table Information, and Components).
- i would like the Components checkbox to activate a macro to turn the components section "On" so that information box will show when the box is selected and be a blank area, or "Off" when it is not checked.
- I would like the Die Information and the Table Information to be exclusive. In other words, I only want to be able to show one or the other in the same place of each "Part" cell group.
- I would like to place the 3 checkboxes above the "components" cell group.

I am not sure where to start with this to be able to have a result as described above and retain the relative formulas in each cell and the conditional formatting.

I would also like to create a button that will insert a new "part" entry below the previous part(a blank part entry using the same format of the two part entries shown). I have played around with this a bit but i keep getting debug errors in certain parts of the macro when i run it.

I am open to suggestions and I appreciate any help you can provide.

Thanks!

Part Status Information Sheet Rev1.1 sample.xlsx