| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy formula only from one spreadsheet to another
Hello,
I have a range of formula's in a spreadsheet that I need to copy to another spreadsheet but when I do a Paste SpecialFormula it copies the actual data and references the original spreadsheet within the formula. Example: Original formula in original spreadsheet is =COUNTA(AutoSys!B:B) and when I paste special to another spreadsheet it is =COUNTA('[Scheduling Metrics April 2007.xls]AutoSys'!C:C). I have a whole worksheet with these formulas that I need to copy on a regular basis, can someone tell me why it won't just copy the formula? I have also tried paste specialFormulas and number formats, values, values and number formats - they all give the same results. Any help would be much appreciated Thanks Lori |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy VLookup formula from one spreadsheet to another | Excel Discussion (Misc queries) | |||
| How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
| In Excel I want to copy text from spreadsheet to spreadsheet | Excel Worksheet Functions | |||
| new copy of spreadsheet using old spreadsheet info. | Excel Discussion (Misc queries) | |||
| Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
