Hi,
I am creating a BoM table. There are different option content for the product. I have a set of checkbox (Form) that I have on the first tab. For instance, the product can have
1. 7.6Kwh
2. 15 Kwh
3. 23 Kwh

the second set of options are:
1. HVAC
2. Heater Only

the third set of options are:
1. Red
2. White
3. Blue

I have separate tabs for each of these option sets and I have created a blank template sheet. I want the macro to populate the blank template based on the selection made on the first page. For instance, if I select 7.6, Heater and White, I want the macro to copy the info from those 3 tabs and paste them in the blank template.

Can this be done? Appreciate the help...