Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Cell validation based on the contents of previous cell

  Asked By: Dora    Date: Feb 05    Category: MS Office    Views: 1240
  

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.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Rene Sullivan     Answered On: Feb 05

This should get you started

See http://www.contextures.com/xlDataVal02.html

 
Didn't find what you were looking for? Find more on Cell validation based on the contents of previous cell Or get search suggestion and latest updates.




Tagged: