Copying Formulas

G

Gingerly

When I copy a formula from one spreadsheet to another (2 different files, not
worksheets within the same file), the file name of the spreadsheet that I am
copying FROM is copied to the cell of the spreadsheet that I am copying TO. I
only want the formula itself, not the spreadsheet name. I tried PASTE
SPECIAL but it didn't work. Thanks in advance for any help.
 
T

trip_to_tokyo

In EXCEL 2007 when doing the Paste Special select the Formulas radio button
then hit OK and you will get just the formula without the spreadsheet name.

If my comments have helped please hit Yes.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Need Help with Macro Security 1
Linking data in MS Word into Excel 5
Excel - Wich Function should I use? 1
Auto Merge text from multiple sources 0
Create a dynamic master file 1
Need Help with a VBA subroutine 0
Paste to excel from word - auto format problem 1

Top