Dropdown menu inside an dropdownmenu

hi,

i have attached excel sheet where you can see what is my problem with dropdowns..

Have a look here:

http://www.contextures.com/xlDataval02.html

It is difficult to understand what exactly you want...

Selecting Data 2 already incorporates Table Y...

I still don't get it. There is no table 2 in this attachment.

hi,

I know i`m not so good in explaining these kind of things
But i try one more time.
The first file that i attached consist of table data 2 and table data 3, you can select from the dropdown menu data 2 or data 3. When you select data 3 it shows the information from sheet 2 from the data 3 table and when you select the data 2 it shows the information from sheet 2 from the data 2 table.

when i select the data 2 there are a table in it starting from F17 and ending to K23.
now i want to make a dropdown menu to cell D16 which would have options table b and table c. so when i have selected first from the cell B3 the data 2 then i could select from the cell D16 one of the listed tables(table c or table b) and by doing that the information in F17 to K23 would change according to selected table. Table b and table c can be in another sheet.

hopefully you get the idea now, i´m running out of words

You can forget the attachment number 2, it was just to show how the dropdown menu should work..

It is not very simple...

See attachment.

It works only if you do not put a formula in D16.

So if you can rearrange data in data3 so that the corresponding cell will always be blank, then it works. Note, right now, the sdgf from N16 on sheet 2 does not display in D16 of sheet1.... please put it in another cell along with corresponding row members.

You will have to incorporate an event macro to automatically clear D16 so that Table select clears automatically....

When you click B3 and it contains data3, then the bottom half of the table clears so that you can make a selection in.