how to create "template columns"
 

i have a set of three columns which have different lookups
and complicated formulas. Each pair of three columns
represents a product group, the problem i am having is
depending on user selection, i need different types of
product groups. for example, if user selects three product
groups, i would need 9 columns with the same formulas.

Currenly I have created 15 product groups in Excel and
depending on user selection, the macro hides unused
product groups, however, this isnt very efficient since my
file size is growing exponentially.

I cant find any way of creating columns depending on user
selection.

I really appreciate all your help.

TIA!
JusTIn