Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Populating or exporting a table IF something is selected

Answered Populating or exporting a table IF something is selected

  • Friday, November 19, 2010 4:34 PM
     
     
    Sign In to Vote
    0

    Currently trying to creat a book that if certain options are selected in a few lists, a table from another book is transported in automaticly due to the choices. is this possible and if so how 

     

All Replies

  • Saturday, November 20, 2010 4:21 PM
     
     Answered
    Sign In to Vote
    0
    It is possible and easy to implement.  Say we have a couple of cells with data validation pull-downs. In the first cell, the user could select Dog, Cat, or Bird.  In the next cell the user could select Small, Medium, or Large.  An event macro would monitor the cells.  For each of the nine possibilities, the macro would have a table defining a source workbook and location of the table.  Once the user selected animal and size, the macro would open the correct file, copy the table information and paste it to the user's spreadsheet and then close the source file.
    gsnu201011