On the button. Excellent Roger. Thanks much....

"Roger Govier" wrote:

Hi

Take a look at the sample workbook I created called FastFilter.
You can download it from Debra Dalgleish's site
http://www.contextures.com/Fastfilter.zip

--
Regards
Roger Govier

"Sivassou..." wrote in message
...
Hi,

I am having Excel data in the following format:

A B C
Country State City
India TN Chennai
India TN Salem
USA FA Texas

When enter "India" in column E1, I want to get following results:

India TN Chennai
India TN Salem

Is there any built in fuction (Expect Advance Auto filter). Your help is
highly appreciated. Thanks.