I have a static data in my database table with five level hierarchy.
something like this.
10 countries

something like this. So basically i have 10*10*10*10 = 10000 records in

my table. I want to get this data into excel in five columns i.e.
country, state, city, branch. Every column will have validation using
list drow down. I know how to create dynamic name range based on 1
column. How can we create this based on two or more columns. Also can i
use dts on click of every cell to get data for filling the list.

Whilst DTS can populate the Excel file for you it really does sound as
though this data should be sourced by Excel itself.

DTS in an On-Click event is possible yes although I dare say more
expensive than a simple call from Excel itself.



"pm" <mittal.pradeep (AT) gmail (DOT) com> wrote