Hi,

Go to the formula you want to copy and select whole formula in frmula bar
and hit Ctrl+C then go to the other sheet active the cell that you want to
copy in and then hit Ctrl+V.
Also you don't need go to cell by cell to delete the file name from the
formula you can delete the file name by using find and replace.

Thanks
--
Farhad Hodjat


"karmela" wrote:

Hi,

is there any possibility to copy formulas from one workbook/worksheet to
another and prevent from reference to the old workbook/worksheet? In this
time I must go cell to cell and delete the old name....

Thanks for help to spare time

karmela