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; [TABLE="width: 331"]
<tbody>[TR]
[TD][TABLE="width: 331"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 331"]
<tbody>[TR]
[TD]Project Number[/TD]
[TD]Project Name[/TD]
[/TR]
[TR]
[TD]C2269[/TD]
[TD]Spring Farm[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]
When the table says Spring Farm, a ready made table (below) will appear.[/TD]
[/TR]
[TR]
[TD][TABLE="width: 171"]
<tbody>[TR]
[TD]Spring Farm[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10/05/2011[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]23/05/2011[/TD]
[TD="align: right"]8
[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col><col></colgroup>[/TABLE]

 

[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