Copy from the formula bar and paste into the formula bar.
Or change the formula to text
select your range of formulas (more than one cell)
edit replace
what: = (equal sign)
with: $$$$$
replace all
copy and paste
and then change the strings back to formulas (edit|replace--in both worksheets)
JR573PUTT wrote:
>
> How can I copy a formula that references another sheet to a new file"
>
> file name: sales
> sumif(sheet1 a:a)
>
> When I copy this formula to a new file the formula is:
> sumif(c:/mydocs.sales 'sheet1! a:a)
>
> I just want the formula to be:
> sumif(sheet1 a:a)
>
> Is this possible?
>
> --
> JR573PUTT
> ------------------------------------------------------------------------
> JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587
> View this thread: http://www.excelforum.com/showthread...hreadid=513310
--
Dave Peterson
Bookmarks