MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Wiljan on February 15, 2002 4:26 AM

I don't got the problem with countrys's but with numbers and payments. I also wanna select a list in validation thats working now. But can i add an action to a selection within the box. for example when i select bank in a list a sum has to be placed in a sertain cell how can i do that ?


I have a list of countries (USA, Australia, England), and a list of cities. How can I make than when the user selects USA in one cell, in the other one appear only cities from USA (New York, Los Angeles), and also for Australia (Camberra, Perth), etc. ?"

Posted by IML on February 15, 2002 6:04 AM

For your first question, use a sumif statement with the criteria argument referencing your validation cell.

For your second question, see

good luck