Advanced Validation Required

[csanjeev99]

In A1 cell It will show only Office.

In C2 cell It will show State.

In E1 cell it will show Division.

In G1 cell it will show District.


Now I will explain relation between office, state, division and district.

One Office can have more than 1 State
One State can have more than 1 Division
One Division can have more than 1 District

[TABLE="width: 921"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]for more details i have given below example of data [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Office[/TD]
[TD]Office Code[/TD]
[TD]State[/TD]
[TD]State Code[/TD]
[TD]Division[/TD]
[TD]Division Code[/TD]
[TD]District[/TD]
[TD]District Code[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Dadra And Nagar Haveli[/TD]
[TD] [/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Dadra And Nagar Haveli[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Daman And Diu[/TD]
[TD] [/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Daman[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Daman And Diu[/TD]
[TD] [/TD]
[TD]Junagarh[/TD]
[TD] [/TD]
[TD]Diu[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmedabad[/TD]
[TD]055[/TD]
[TD]Ahmadabad[/TD]
[TD]474[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmadabad[/TD]
[TD]055[/TD]
[TD]Bhavnagar[/TD]
[TD]481[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmedabad[/TD]
[TD]055[/TD]
[TD]Gandhinagar[/TD]
[TD]473[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmedabad[/TD]
[TD]055[/TD]
[TD]Kheda[/TD]
[TD]483[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmedabad[/TD]
[TD]055[/TD]
[TD]Surendranagar[/TD]
[TD]475[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Patan[/TD]
[TD]054[/TD]
[TD]Banaskantha[/TD]
[TD]469[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Kachchh[/TD]
[TD]468[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Patan[/TD]
[TD]054[/TD]
[TD]Mahesana[/TD]
[TD]471[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Patan[/TD]
[TD]054[/TD]
[TD]Patan[/TD]
[TD]470[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Patan[/TD]
[TD]054[/TD]
[TD]Sabarkantha[/TD]
[TD]472[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Amreli[/TD]
[TD]480[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Jamnagar[/TD]
[TD]477[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Junagadh[/TD]
[TD]479[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Porbandar[/TD]
[TD]478[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Rajkot[/TD]
[TD]056[/TD]
[TD]Rajkot[/TD]
[TD]476[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Bharuch[/TD]
[TD]488[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Navsari[/TD]
[TD]490[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Surat[/TD]
[TD]492[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Tapi[/TD]
[TD]493[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]The Dangs[/TD]
[TD]489[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Surat[/TD]
[TD]058[/TD]
[TD]Valsad[/TD]
[TD]491[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Ahmedabad[/TD]
[TD]055[/TD]
[TD]Anand[/TD]
[TD]482[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Vadodara[/TD]
[TD]057[/TD]
[TD]Dohad[/TD]
[TD]485[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Vadodara[/TD]
[TD]057[/TD]
[TD]Narmada[/TD]
[TD]487[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Vadodara[/TD]
[TD]057[/TD]
[TD]Panchmahal[/TD]
[TD]484[/TD]
[/TR]
[TR]
[TD]Ahmedabad[/TD]
[TD]01[/TD]
[TD]Gujrat[/TD]
[TD]24[/TD]
[TD]Vadodara[/TD]
[TD]057[/TD]
[TD]Vadodara[/TD]
[TD]486[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Bangalore Rural[/TD]
[TD]583[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Bangalore Urban[/TD]
[TD]572[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Chikkaballapur[/TD]
[TD]582[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Chitradurga[/TD]
[TD]566[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Davanagere[/TD]
[TD]567[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Kolar[/TD]
[TD]581[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Ramanagara[/TD]
[TD]584[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Shimoga[/TD]
[TD]568[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Bangalore[/TD]
[TD]084[/TD]
[TD]Tumakuru[/TD]
[TD]571[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Bagalkot[/TD]
[TD]556[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Belgaum[/TD]
[TD]555[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Bijapur[/TD]
[TD]557[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Dharwad[/TD]
[TD]562[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Gadag[/TD]
[TD]561[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Haveri[/TD]
[TD]564[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Belgaum[/TD]
[TD]085[/TD]
[TD]Uttara Kannada[/TD]
[TD]563[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Bellary[/TD]
[TD]565[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Bidar[/TD]
[TD]558[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Gulbarga[/TD]
[TD]579[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Koppal[/TD]
[TD]560[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Raichur[/TD]
[TD]559[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Gulbarga[/TD]
[TD]086[/TD]
[TD]Yadgir[/TD]
[TD]580[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Chamarajanagar[/TD]
[TD]578[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Chikamagalur[/TD]
[TD]570[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Dakshina Kannada[/TD]
[TD]575[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Hassan[/TD]
[TD]574[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Kodagu[/TD]
[TD]576[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Mandya[/TD]
[TD]573[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Mysore[/TD]
[TD]577[/TD]
[/TR]
[TR]
[TD]Bangalore[/TD]
[TD]02[/TD]
[TD]Karnataka[/TD]
[TD]29[/TD]
[TD]Mysore[/TD]
[TD]087[/TD]
[TD]Udupi[/TD]
[TD]569[/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

What exactly is your question?

 

[csanjeev99]

As you now I am new user, could you please let me know the way to attache my file so that I can explain my problem properly.

 

[csanjeev99]

Thanks Rick, could you please help me to upload my excel file so that I can explain you my problem in proper way

 

[Rick Rothstein]

Thanks Rick, could you please help me to upload my excel file so that I can explain you my problem in proper way

This forum does not permit the uploading of files. You can share it using a DropBox or OneDrive account (if you have one) or posting it to one of the free file-sharing websites (such as http://www.box.net/files). However, my original question to you was asking what did you want to do with the data you posted in Message #1. All you said in the title was "Advanced Validation Required", but the body of your message never told us what the nature of that validation was.

 

[csanjeev99]

See I am Having a data base which is having below field:

Office - State - Dvision - District

A1 cell I have validate with Name of Office as you can see in Message # 1 Office Names Ahmedabad & Bangalore like this I have 14 office Names.

C2 cell I have validate with Name of State but if I selected Ahemdabad in A1 cell then C2 have to give option of two states only, which it covers as you can see in message#1, kindly note one office can have more than 1 State.

E1 cell I have validate with Name of Division but if I selected Ahemdabad in A1 cell then Gujrat in C2 cell, then E2 haveto give division options of Gujrat State only which covered by Gujrat as you can see in message#1,

Now G1 cell have to give District in options wich is covered by selected division in E1.

 

[csanjeev99]

Please help me if u r having solution

 

[csanjeev99]

Dear All Kindly Help me to resolve m problem

 

[csanjeev99]

Is there anyone for my help

 

[csanjeev99]

Dear Advisers or Members or experts,

Kindly let me know will you have solution for my problem or not..?