software

How can I copy a formula that references another sheet to a new filequot;

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: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=513326
.................................................. ..............--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
View this thread: www.excelforum.com/showthread...hreadid=513326Copy from the formula bar.

Or check out using quot;Copy Formulaquot; and quot;Paste Formulaquot; 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
www.mvps.org/dmcritchie/excel/rightclick.htm

You might also take a look at
www.mvps.org/dmcritchie/excel/xlnews.htm#forums
and only robots would answer questions within 10 minutes
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: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;JR573PUTTquot; gt; wrote in message
...
gt;
gt; How can I copy a formula that references another sheet to a new filequot;
gt;
gt; file name: sales
gt; sumif(sheet1 a:a)
gt;
gt; When I copy this formula to a new file the formula is:
gt; sumif(c:/mydocs.sales 'sheet1! a:a)
gt;
gt; I just want the formula to be:
gt; sumif(sheet1 a:a)
gt;
gt; Is this possible?
gt;
gt;
gt; --
gt; JR573PUTT
gt; ------------------------------------------------------------------------
gt; JR573PUTT's Profile: www.excelforum.com/member.php...oamp;userid=31587
gt; View this thread: www.excelforum.com/showthread...hreadid=513326
gt;