+ Reply to Thread
Results 1 to 2 of 2

Marco: Exract text (table) between sheets when selected in dropdown

Hybrid View

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Reykjavik, Iceland
    MS-Off Ver
    Excel 2013
    Posts
    4

    Marco: Exract text (table) between sheets when selected in dropdown

    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. I've attached my workbook in case

    Thank you in advance
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-12-2013
    Location
    Reykjavik, Iceland
    MS-Off Ver
    Excel 2013
    Posts
    4

    Re: Marco: Exract text (table) between sheets when selected in dropdown

    So I want the tables from the Insulation Thickness sheet to appear below the dropdown in the Main sheet when they are selected from the dropdown. It would be ideal if it would be possible to select as many tables as the user want, so they appear next to each other.
    Eg. if the user first selects Roof from the first dropdown and then table 6. Table 6 should then appear. The user could then pick Concrete Walls and table 1. Table 1 would then appear next to table 6 previously choses. And so on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1