Hi all,

I am currently working on a marketing dashboard and have a questions. I have a "Campaigns" area where the person using the dashboard would select the campaign "calling campaign", "web base marketing", etc. For each of the possible campaigns selected the column names would change and the amount of columns would change as well as the amount of rows. Right now I am simply using vlookup functions to fetch the data but is there another tutorial or way to change the entire area and change it? Example: If you chose web based marketing from my combo box the table would increase in columns and decrease in rows automatically. Right now I am not using this area as a table.

Is there a way I could create the completed tables on another sheet and if you chose whatever combo box option you could just get that table to appear?

Additional details: I am running excel 2010, in compatability mode so it would work for users with 2003.

Thanks.