Hi Charlesdh,

Here is the link:
http://www.mrexcel.com/forum/excel-q...teria-met.html

Note: I have gone through the forums and also the web to find out if I could find a code or something similar to works for my requirement. As I could not find the code as per my requirements I had to request for some Pro to help.

The code here looks similar, but not what my requirement is, see link below.
http://www.mrexcel.com/forum/excel-questions/508240-visual-basic-applications-copy-rows-based-criteria-new-sheet-file-3.html

Thanks