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
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.