software

i have a worksheet with formulas, i want to copy the absolute figures to
another worksheet, pl help

Hi!

Use Copy/Paste Specialgt;Values

Biff

quot;kamleshquot; gt; wrote in message
news
gt;i have a worksheet with formulas, i want to copy the absolute figures to
gt; another worksheet, pl help
Copy then Paste Special/Values.

HTH
JG

quot;kamleshquot; wrote:

gt; i have a worksheet with formulas, i want to copy the absolute figures to
gt; another worksheet, pl help

thanks a ton it worked very well.
can the same formatting also be copied.

quot;pinmasterquot; wrote:

gt; Copy then Paste Special/Values.
gt;
gt; HTH
gt; JG
gt;
gt; quot;kamleshquot; wrote:
gt;
gt; gt; i have a worksheet with formulas, i want to copy the absolute figures to
gt; gt; another worksheet, pl help

thanks a lot. it worked!!

quot;Biffquot; wrote:

gt; Hi!
gt;
gt; Use Copy/Paste Specialgt;Values
gt;
gt; Biff
gt;
gt; quot;kamleshquot; gt; wrote in message
gt; news
gt; gt;i have a worksheet with formulas, i want to copy the absolute figures to
gt; gt; another worksheet, pl help
gt;
gt;
gt;