I have been trying to streamline filling the address list of our
customers with correct spelling of Country, State, District/City
(province) etc.

Row 1 is set for header namely in A1, B1, C1, D1 ....

When A2 is filled with "India" B2 should be allowed to be filled with
validated list of names of States of India only through a drop-down
list. B2 should be always with referene to A2. If A2 is filled with
"USA", B2 should not be allowed to be filled with the states of other
countries. It should be allowed to be filled with the states of USA
only.

Further C2 should be validated with reference to the entry thus made in
B2. The Cities of particular State (dropped from the drop-down list of
States of India in B2) only should be validated for C2.

Like wise all consecutive cells should be based on the cell in the
previous column. At least 8 coloumns till I complete District, Mandal,
Village, Zip/Pin Code etc which are fixed and will be typed in lists in
the same worksheet or elsewhare

Will any body please help me to complete my job easily as filling the
data 'as it is' from hand written bills/invoices etc. would lead to
spelling mistakes and further programming or getting results would not
be accurate/complete.