Copying Formula
Hi Guys
I will be grateful if you can solve my problem Whenever i am copying formula from one worksheet to another worksheet, it is copying the contents of formula itself (e.g. ='worksheetA'!D12) not the formula result. Thanks nc |
Copying Formula
It actually copies everything, you make the choice when you paste. Try paste
special - value "nc" wrote: Hi Guys I will be grateful if you can solve my problem Whenever i am copying formula from one worksheet to another worksheet, it is copying the contents of formula itself (e.g. ='worksheetA'!D12) not the formula result. Thanks nc |
Copying Formula
Hi
It sounds as though the cell you are pasting to is formatted as Text. Try formatting the cell as General, then do the Copy/Paste -- Regards Roger Govier "nc" wrote in message oups.com... Hi Guys I will be grateful if you can solve my problem Whenever i am copying formula from one worksheet to another worksheet, it is copying the contents of formula itself (e.g. ='worksheetA'!D12) not the formula result. Thanks nc |
Copying Formula
Try editing the new formula by deleting the equal sign and pressing Enter,
then editing it again and re-inserting the equal sign......... Vaya con Dios, Chuck, CABGx3 "nc" wrote in message oups.com... Hi Guys I will be grateful if you can solve my problem Whenever i am copying formula from one worksheet to another worksheet, it is copying the contents of formula itself (e.g. ='worksheetA'!D12) not the formula result. Thanks nc |
All times are GMT +1. The time now is 11:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com