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.