How do I copy this formula ='Daily Takings'!C29-B7-D7-E7 from a cell in
one workbook to a cell in another totaly unrelated workbook without the
formula altering to accomatate its new position and without it relating back
to its old workbook. At the moment the formula when moved adds the title of
the old workbook at the start of the formula so that it ends up looking like
this:- ='[NEW A 10th Amended Accounts Cental Cafe 19.7.09.to18.07]Daily
Takings'!C29-B7-D7-E7
I have put the $ sign before the letters/numbers like so ='Daily
Takings'!$C$29-$B$7-$D$7-$E$7 and this works with that part of the formula
but what do I do about the:- ='Daily Takings'! part.

Hope that all makes sense.
--
Thanks Becky

If I understand your question correctly, select the cell and then select all
the text in the Formula Bar, press Ctrl+C (or click Edit/Copy menu item) to
copy the text into the Clipboard, go to your new location and press Ctrl+V
(or click Edit/Paste menu item) to paste that text into the cell.

--
Rick (MVP - Excel)


"Rebecca" wrote in message
...
How do I copy this formula ='Daily Takings'!C29-B7-D7-E7 from a cell
in
one workbook to a cell in another totaly unrelated workbook without the
formula altering to accomatate its new position and without it relating
back
to its old workbook. At the moment the formula when moved adds the title
of
the old workbook at the start of the formula so that it ends up looking
like
this:- ='[NEW A 10th Amended Accounts Cental Cafe 19.7.09.to18.07]Daily
Takings'!C29-B7-D7-E7
I have put the $ sign before the letters/numbers like so ='Daily
Takings'!$C$29-$B$7-$D$7-$E$7 and this works with that part of the
formula
but what do I do about the:- ='Daily Takings'! part.

Hope that all makes sense.
--
Thanks Becky

You can try editing your links when you do that and link it to the current
workbook.

"Rebecca" wrote:

How do I copy this formula ='Daily Takings'!C29-B7-D7-E7 from a cell in
one workbook to a cell in another totaly unrelated workbook without the
formula altering to accomatate its new position and without it relating back
to its old workbook. At the moment the formula when moved adds the title of
the old workbook at the start of the formula so that it ends up looking like
this:- ='[NEW A 10th Amended Accounts Cental Cafe 19.7.09.to18.07]Daily
Takings'!C29-B7-D7-E7
I have put the $ sign before the letters/numbers like so ='Daily
Takings'!$C$29-$B$7-$D$7-$E$7 and this works with that part of the formula
but what do I do about the:- ='Daily Takings'! part.

Hope that all makes sense.
--
Thanks Becky

highlight your formula - - click copy - - - X out page and when you are
prompt to save click cancell - - - open your new work book and right click
and paste were you want your formula
--
grizz


"Rebecca" wrote:

How do I copy this formula ='Daily Takings'!C29-B7-D7-E7 from a cell in
one workbook to a cell in another totaly unrelated workbook without the
formula altering to accomatate its new position and without it relating back
to its old workbook. At the moment the formula when moved adds the title of
the old workbook at the start of the formula so that it ends up looking like
this:- ='[NEW A 10th Amended Accounts Cental Cafe 19.7.09.to18.07]Daily
Takings'!C29-B7-D7-E7
I have put the $ sign before the letters/numbers like so ='Daily
Takings'!$C$29-$B$7-$D$7-$E$7 and this works with that part of the formula
but what do I do about the:- ='Daily Takings'! part.

Hope that all makes sense.
--
Thanks Becky