Drop Box that generates a chosen table already made

[xODK]

I dont know quite how to explain this but I will definitely try my best.

Scenario:
I have 5 different tables, all having the same headers. The values under are Vlookups.

Objective:
Create a dropbox that lists (Table 1, Table 2, etc.)
For whichever table is picked, is the one that will show.

For example, if I want table 1 to populate, I would chose table one in the drop box and so on for the rest of the other tables.

[TMS]

If you have the basic workbook with some sample data, I suggest you share it for the structure and content layout.

Possibly just a case of using INDIRECT.

Regards, TMS

[xODK]

2-6-2014 10-40-03 AM.png

Here are 2 out of the five tables

[xODK]

2-6-2014 10-40-03 AM.png


Here are 2 out of the 5 tables

[newdoverman]

Here is a discussion on the subject http://social.technet.microsoft.com/...ks?forum=excel

Hope this helps.

[xODK]

I am trying to bring it up and populate it on a different sheet. So naming the cells wont necessarily work since I need it on the main sheet. The tables are in a different sheet and i wanted to bring them up one at a time. I hope that makes sense.

[newdoverman]

The best solution may be to use VBA to copy the table and Paste a copy of it as needed. The gist of the conversation that I pointed you to was that the drop down wouldn't work and going to the table was the best solution using F5 as described by Ron de Bruin.

Are you wanting to work with this table? If yes, then I don't suggest having a copy made but go to the actual table instead.