Dear mana thx a lot its working, i need one more filter with this could u plz help for that, like in E column country name are listed, after filtering the date if i want to filter country than what would be the code. i want to write the country name in A3 and that will be filtered in column E. tnx