Please I need Your Help (Shrink lists )

[ATAHER]

Hi To All ,
I face aproblem here with lists , i will explain it down:
Example:
Suppose I havw drop down list contain the following main category : Assets , Customers , Suppliers.

Assets Customers Suppliers
Fixed Assets Local Local
Current Assets International International


Fixed Assets Local Local
Car Customer ABC Supplier STU
Building Customer XYZ Supplier LMN

Current Assets International International
Cash Customer 123 Supplier 444
Inventory Customer 999 Supplier 555


So , If i have 3 drop down lists the first one contain the main category : Assets,Customers , Suppliers the second one for Sub Category : (Fixed Assets , Current Assets )- (Local Cust , International Cust)- (Local Supp , International Supp) the third list is for Sub-Sub category as i display above . the question is : i want when i select from the first list for example Assets the second list mandatory should be current assets and fixed assets and if i select from the second list current Assets the third list mandatory be cash and inventory .

Please My Firends Help Me .

Thanking You in Advance

 

[VoG]

Take a look at dependent data validation lists http://www.contextures.com/xlDataVal02.html

 

[ATAHER]

Thanks alot Sir, very grateful