Copy Formula's

[JR573PUTT]

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]

................................................................

[David McRitchie]

Copy from the formula bar.

Or check out using "Copy Formula" and "Paste Formula" by Chip Pearson,
there were some corrections in his original posting and you will find more
complete installation information in
Right Click Menus (Context Menus) in Excel
http://www.mvps.org/dmcritchie/excel/rightclick.htm

You might also take a look at
http://www.mvps.org/dmcritchie/excel/xlnews.htm#forums
and only robots would answer questions within 10 minutes
http://www.mvps.org/dmcritchie/excel/posting.htm
there are well over 1,000 postings in the newsgroups per dayu
allow 24 hours for people to answer.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"JR573PUTT" <[email protected]> wrote in message
news:[email protected]...
>
> 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=513326
>