Hi everyone,

I have an interactive excel worksheet that pulls down data for my organisation based on period selection from list box.

My list box is

1) Years (2006 to 2012)
2) Quarter 2012 (Q1 to Q4)
3) Months 2012 (Jan to Dec)

I want to assign macro to these entries that would hide needless columns based on the selection.
For example for Case 3: Months 2012 (Jan to Dec) I need 12 columns (Colum B to Column M) but for case 1, I would need only 7 columns so I want the columns I to M to automatically hide when this case is selected. Similalry for case 2, I only need 4 columns and want the remaining columns to automatically hide.

Would be grateful for your help.

Thanks,
Zubair