| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy Formula's
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Formula's
.................................................. .............. -- JR573PUTT ------------------------------------------------------------------------ JR573PUTT's Profile: http://www.excelforum.com/member.php...o&userid=31587 View this thread: http://www.excelforum.com/showthread...hreadid=513326 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy Formula's
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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to copy only the layout and formulas and not the exisiting | Excel Discussion (Misc queries) | |||
| How to copy formulas from one workbook to another | Excel Discussion (Misc queries) | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| Copy formulas - strange things happens | Excel Discussion (Misc queries) | |||
| how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
Linear Mode
