Hi
There are many examples available on the net. here is one of them.
http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please He
Pls update my requirement.i want to display items with the headings in the
second combo box with the criteria based on first combobox.
For example
Col A (COMBO BOX 1) COL B (COMBO BOX 2)
ASIA ASIA HEADING
AUSTRALIA
