Data validation and vlookup over 12 tables of data

[Joe W]

Hello,

I hope someone can please please help me. I have 12 tables of data
seperated by country, with each table showing sales each year for 10 years by
product group.
i.e A1 Cheese A2 Butter etc etc with the year across the top. What I want
to do it have this data for each country on one worksheet with some sort of
data validation drop down tool and a lookup so I can use the drop down to
select a country and then the table for that country will appear below. I
have tried a very basic vlookup which gave me the data for the first country
but when I used another it came back with no data.

Does anyone have an idea of how I can achieve this??

Thank you very very much if you can help.

KR

Joe W

 

[NBVC]

HOW TO GET FURTHER HELP WITH A WORKBOO
For further help with it why not join our forums (shown i
the link below) it's completely free, if you do join you will have th
opportunity to add attachments to your posts so you can add workbooks t
better illustrate your problems and get help directly with them. Also i
you do join please post in this thread (link found below) so that peopl
who have been following or helping with this query can continue to d
so. :

--
NBV

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Consolidate Tables.
No code, no formulas, no membership.
http://www.mediafire.com/file/ztownamuttd/09_10_09.xlsx