Copy formula only from one spreadsheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 Special>Formula 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 special>Formulas and number formats,
values, values and number formats - they all give the same results.
Any help would be much appreciated
Thanks
Lori
 
It's behaving the way it is supposed to.

Try selecting the range of formulas to copy, pressing Ctrl-H and replacing
the = sign with your name - Replace All
Then copy the changed formulas, paste them into the new sheet
Do another Search & Replace, changing your name to an equal sign
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Formula ONLY 2
Copying cells from one spreadsheet to another? 7
Copying a formula but only getting the result 3
drag formula down from columns that go acros 3
Lookup returning wrong results 0
formula finds values in apparently blank cells 1
Return of value when copying a formula 4
Copy If rows to another worksheet 1

Back
Top