To create a dynamic table based with number of columns equal to the number entered by user from a drop down list

[Aruj Kapoor]

HI Everyone,

I want to create a table with required number of columns equal to the number entered through a drop down list created by data validation.

Eg: User enters 3 through a drop down menu, excel should display a table with 3 columns with columns names as Month 1, month 2 and month 3. How can i do this ?

Please help me

Best regards
Aruj Kapoor