Copy Data and paste it in new sheet and save new sheet as value of cell a2

Dear Experts,

I am trying to copy few lines of data (Filtered) from an existing file and paste it in new worksheet. After this I want to save the worksheet as value in Range(“a2”) of the new sheet . The code I am using is

Please Login or Register  to view this content.

This is saving the workbook with the value of original sheets range(“A2”) not with new sheets value in range(“A2”). Please advise.
Best Regards/VKS