I used your suggested method as above and it worked well for 7,000 records (about 90 seconds) 438Kb.
Thanks John L
I am working on excel for long time. Importing conditional data from another excel is quite easy. you have to follow some simple steps without using vba and by using formula. For this purpose please visit the link below