Advanced Validation Required

csanjeev99

New Member
Joined
Aug 17, 2014
Messages
9
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]
 
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.
 
Upvote 0
Thanks Rick, could you please help me to upload my excel file so that I can explain you my problem in proper way
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top