ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   copy absolute figures and not formula (https://www.excelbanter.com/excel-discussion-misc-queries/69971-copy-absolute-figures-not-formula.html)

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

Biff
copy absolute figures and not formula
 
Hi!

Use Copy/Paste SpecialValues

Biff

"kamlesh" wrote in message
...
i have a worksheet with formulas, i want to copy the absolute figures to
another worksheet, pl help

pinmaster
copy absolute figures and not formula
 
Copy then Paste Special/Values.

HTH
JG

"kamlesh" wrote:

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

kamlesh
copy absolute figures and not formula
 
thanks a ton it worked very well.
can the same formatting also be copied.

"pinmaster" wrote:

Copy then Paste Special/Values.

HTH
JG

"kamlesh" wrote:

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

kamlesh
copy absolute figures and not formula
 
thanks a lot. it worked!!

"Biff" wrote:

Hi!

Use Copy/Paste SpecialValues

Biff

"kamlesh" wrote in message
...
i have a worksheet with formulas, i want to copy the absolute figures to
another worksheet, pl help


All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com