Formula copying from one workbook to another...

  • Thread starter Thread starter MarksNWO
  • Start date Start date
M

MarksNWO

Hello Excel community friends.

Here's my problem: I trying to copy a formula from a
worksheet in one workbook to a worksheet (of the same name
and same cell location) in another workbook.

Say the formula from workbook1/worksheet1 is =sum(1+1) and
the name of workbook1 is "Me" and the name of the
worksheet1 is "Sheet1" and located in cell A1.

Of course, when you copy the formula from "Me" to another
workbook (named, say, "You") and to the same location (A1)
and on the same named worksheet, "Sheet1", the preface of
the formula is something to the effect of "[Me]Sheet1!a1...

What I wish to accomplish is to copy the formula
from "Me" to "You" with the formula picking up the
attributes of "You", so that other worksheet formula
references in "You" will be able to link to this new
formula without generating a #REF error.

Thank you.

Mark
 
Hi
try copying the formula from within the formula. e.g. select the
formula in the formula bar, hit CTRL+C and select the formula bar in
your second workbook. to insert the formula simply press CTRL+V
 

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 formulas from one workbook to another workbook 2
Reference to another worksheet cell in a sumproduct formula 1
summarizing data from various workbooks 3
Copy absolute formulas 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Ref Formula Query 1
Can I Move replace instead of Move copy 2
problems getting this macro to work 23

Back
Top