View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Reproducing sheets with values only

Hi Ravi

to add on..........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 this post helps click Yes
---------------
Jacob Skaria


"Ravi Kumar" wrote:

I want to creat a copy from a filled up templet workbook with results /
values only instead of formulas in the templet. In other words the copy of
the templet should contain only result of formulas not formulas. Help Please.