+ Reply to Thread
Results 1 to 5 of 5

Macro: Using drop-down list to extract whole table from one sheet to another

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

    Question Macro: Using drop-down list to extract whole table from one sheet to another

    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

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro: Using drop-down list to extract whole table from one sheet to another

    Hello binni88,

    Welcome to the Forum!

    It would be easier to answer your questions and provide you with solutions if you post your workbook.

    To Post Your Workbook
    1. At the bottom right of the Reply window, Click the button Go Advanced
    2. At the top of the Your Message Window, in the first row of icons, Click the Paperclip icon.
    3. Click the Add Files button at the top right in the dialog box. This displays the File Manager dialog.
    4. Click the Select Files button at the bottom middle of the dialog.
    5. In the new window Find the file you want to upload, select it, and Click Open.
    6. You will now be back in the File Manager dialog. Click the bottom Middle button Upload File.
    7. Wait until the file has completely uploaded before you exit the File Manager dialog.

    File Manger Picture
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

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

    Re: Macro: Using drop-down list to extract whole table from one sheet to another

    Hello Leith

    Thank you for the answer. I have uploaded my workbook. 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.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    08-02-2012
    Location
    Pune
    MS-Off Ver
    Office 365 (Win 10)
    Posts
    489

    Re: Macro: Using drop-down list to extract whole table from one sheet to another

    How to delete this post? I accidently posted something here

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Macro: Using drop-down list to extract whole table from one sheet to another

    Hello binni88,

    This has been more difficult than I had expected. You have a lot of unusual elements in this workbook. So I need to know what can be changed.

    First are the textboxes you are using with the tables. I can see why you would want to use them to display the math font but copying these and positioning them each time a table is copied is not practical.
    Second are the formulas. Generally speaking, mixing VBA and formulas seldom works well. Do you need these formulas to function after the table has been copied or can just the values and formatting be copied instead?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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