Table Only Visible When Selected From a Drop-Down list

[mike&jess]

Hi,

I was just wondering is there was a way to Select a project name from a drop down list, then match its name up with the name of a table, and the table will appear on a worksheet.

Eg;

Project Number Project Name C2269 Spring Farm <tbody> </tbody> <tbody> </tbody>
When the table says Spring Farm, a ready made table (below) will appear.
Spring Farm 10/05/2011 2 23/05/2011 8 <tbody> </tbody><colgroup><col><col></colgroup>

<tbody>
</tbody><colgroup><col><col></colgroup>

 

[Gary's Student]

There are several possible approaches:

1. Have the tables on a worksheet and have the drop-down cell feed a cell with a HYPERLINK() formula. You pick the table name and then click on the hyperlink.
2. Using an event macro, detect the pull-down selection and copy the table to an adjacent area.
3. Using an event macro, detect the pull-down selection and display the appropriate table as a Picture.

 

[mike&jess]

Thanks, but unsure how to use macros, or any sort of vba. Any hints, please?

 

[Gary's Student]

I have placed a sample on my SkyDrive. Click on A1 to pick the table; click on B1 to jump to that table:

https://skydrive.live.com/redir?resid=46F2D0FE5F97AADB!464

 

[mike&jess]

I have placed a sample on my SkyDrive. Click on A1 to pick the table; click on B1 to jump to that table:

https://skydrive.live.com/redir?resid=46F2D0FE5F97AADB!464

Thanks, we'll adapt it from that