Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to create a scatter chart with 2 "X" values with common "Y"s | Charts and Charting in Excel | |||
cannot use "Create List" and "Share Workbook" same time | Excel Discussion (Misc queries) | |||
create links to check boxes marked "good" fair"and "bad" | Excel Worksheet Functions |