Thanks MD and coding works fine... showing up the expected results...

And one more concern regarding this..

If i run the macro in the "PAID & WAIT" sheet its not showing up the values, instead if run the macro in Sheet 1(Active sheet) its giving me the expected result.. I dont know why and what makes the difference..

Any idea on this...
Once again thanks for all your help..
Learned a lot and quite interested in learning new things...

-Sindhuja