Hey guys
I am relatively new to the macro programming in Excel. I am working on a project and experiencing a problem regarding how to use drop-down list in order to copy/extract text (table) from one sheet to another within the same workbook. Below is a better description of what I want:
I have one sheet with several tables (each 6 col and 20 row in size) which all have named ranges. In another sheet I have two dropdown lists. The first one asks the user to choose types of data they would want (5 types). The second list (dependent on the first) gives a few possibilites for each type. When the user chooses from the second list I wan't the corresponding table from the first sheet to apper (somewhere) below the drop-down list. Then the user is to be able to choose another type from the first dropdown and then from the second list so the second table appers besides the first table. And so on.
Is there any way to make macro for this (or even a better way)?
Hope you guys can understand what I am asking for
Thank you in advance
Bookmarks