Table Format and Data Validation

[peazmo]

my data in Table Format...

Column A = List of Countries
Coulmn B = List of Provinces/States
Column C = List of Towns

On my report table, I want to use or apply validation such that when I choose a country, only the list of provinces from that particular country appears on the dropdown list (not all list of provinces).

any help please?

 

[mmmarks]

try dis,

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