Please check the replies for your previous post.

if you are looking to do that manually; use Ctrl+A to
select and copy. Target sheet Ctrl+A and Right click Paste special|Values.....

If programatically refer the post by Mike H

If this post helps click Yes
---------------
Jacob Skaria


"Ravi Kumar" wrote:

I am trying to save a copy from a template which contains values in place of
formulas. I want user to enter inputs in to template sheet allow the user to
save copy with results of formula alone. The origional formula shall not be
copied to copy saved from my template. Please help.

Thanks