Hi Friend,

Thanks it is working, A small change required.

1) Both sheets needs to remain as the original sheets name(from where we copied)
2) New workbook needs to save in a specified location. Example"D:\Reports"

Plz help to amend the code.

Regards,

Prabhu