software

Is there a way to copy and page formulas from one workbook to another without
it trying to link the pages to the original workbook? I pasted pages and
some of the formulas without my knowledge were linked.

You can copy the formula out of the formula bar, or you can press F2 and copy
the formula from inside the cell, but in either case, select everything in
the formula excluding the quot;=quot;. You can then paste the formula into your
target workbook by moving to the target cell, typing an equal sign and
pressing Ctrl V to paste the text of the formula into the cell.
--
Kevin Backmannquot;jacobquot; wrote:

gt; Is there a way to copy and page formulas from one workbook to another without
gt; it trying to link the pages to the original workbook? I pasted pages and
gt; some of the formulas without my knowledge were linked.

What if the whole page is full of formulas? Like 100 of them?

Thanks!

quot;Kevin Bquot; wrote:

gt; You can copy the formula out of the formula bar, or you can press F2 and copy
gt; the formula from inside the cell, but in either case, select everything in
gt; the formula excluding the quot;=quot;. You can then paste the formula into your
gt; target workbook by moving to the target cell, typing an equal sign and
gt; pressing Ctrl V to paste the text of the formula into the cell.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;jacobquot; wrote:
gt;
gt; gt; Is there a way to copy and page formulas from one workbook to another without
gt; gt; it trying to link the pages to the original workbook? I pasted pages and
gt; gt; some of the formulas without my knowledge were linked.

Select the range to copy
Edit|replace
what: = (equal sign)
with: $$$$$
replace all

copy and paste these text strings to where you want them.

Then select that pasted range
edit|replace
what: $$$$$
with: =
replace all

Now the text strings are converted back to formulas.

Don't forget to fix the original range, too.

jacob wrote:
gt;
gt; What if the whole page is full of formulas? Like 100 of them?
gt;
gt; Thanks!
gt;
gt; quot;Kevin Bquot; wrote:
gt;
gt; gt; You can copy the formula out of the formula bar, or you can press F2 and copy
gt; gt; the formula from inside the cell, but in either case, select everything in
gt; gt; the formula excluding the quot;=quot;. You can then paste the formula into your
gt; gt; target workbook by moving to the target cell, typing an equal sign and
gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt; gt; --
gt; gt; Kevin Backmann
gt; gt;
gt; gt;
gt; gt; quot;jacobquot; wrote:
gt; gt;
gt; gt; gt; Is there a way to copy and page formulas from one workbook to another without
gt; gt; gt; it trying to link the pages to the original workbook? I pasted pages and
gt; gt; gt; some of the formulas without my knowledge were linked.

--

Dave Peterson

This did not work for copying and replacing a whole page.

quot;Dave Petersonquot; wrote:

gt; Select the range to copy
gt; Edit|replace
gt; what: = (equal sign)
gt; with: $$$$$
gt; replace all
gt;
gt; copy and paste these text strings to where you want them.
gt;
gt; Then select that pasted range
gt; edit|replace
gt; what: $$$$$
gt; with: =
gt; replace all
gt;
gt; Now the text strings are converted back to formulas.
gt;
gt; Don't forget to fix the original range, too.
gt;
gt; jacob wrote:
gt; gt;
gt; gt; What if the whole page is full of formulas? Like 100 of them?
gt; gt;
gt; gt; Thanks!
gt; gt;
gt; gt; quot;Kevin Bquot; wrote:
gt; gt;
gt; gt; gt; You can copy the formula out of the formula bar, or you can press F2 and copy
gt; gt; gt; the formula from inside the cell, but in either case, select everything in
gt; gt; gt; the formula excluding the quot;=quot;. You can then paste the formula into your
gt; gt; gt; target workbook by moving to the target cell, typing an equal sign and
gt; gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt; gt; gt; --
gt; gt; gt; Kevin Backmann
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;jacobquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Is there a way to copy and page formulas from one workbook to another without
gt; gt; gt; gt; it trying to link the pages to the original workbook? I pasted pages and
gt; gt; gt; gt; some of the formulas without my knowledge were linked.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Which part didn't work?

And you selected all the cells first?

jacob wrote:
gt;
gt; This did not work for copying and replacing a whole page.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Select the range to copy
gt; gt; Edit|replace
gt; gt; what: = (equal sign)
gt; gt; with: $$$$$
gt; gt; replace all
gt; gt;
gt; gt; copy and paste these text strings to where you want them.
gt; gt;
gt; gt; Then select that pasted range
gt; gt; edit|replace
gt; gt; what: $$$$$
gt; gt; with: =
gt; gt; replace all
gt; gt;
gt; gt; Now the text strings are converted back to formulas.
gt; gt;
gt; gt; Don't forget to fix the original range, too.
gt; gt;
gt; gt; jacob wrote:
gt; gt; gt;
gt; gt; gt; What if the whole page is full of formulas? Like 100 of them?
gt; gt; gt;
gt; gt; gt; Thanks!
gt; gt; gt;
gt; gt; gt; quot;Kevin Bquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You can copy the formula out of the formula bar, or you can press F2 and copy
gt; gt; gt; gt; the formula from inside the cell, but in either case, select everything in
gt; gt; gt; gt; the formula excluding the quot;=quot;. You can then paste the formula into your
gt; gt; gt; gt; target workbook by moving to the target cell, typing an equal sign and
gt; gt; gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt; gt; gt; gt; --
gt; gt; gt; gt; Kevin Backmann
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;jacobquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Is there a way to copy and page formulas from one workbook to another without
gt; gt; gt; gt; gt; it trying to link the pages to the original workbook? I pasted pages and
gt; gt; gt; gt; gt; some of the formulas without my knowledge were linked.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Either Dave misunderstood or you did it incorrectly, if you are trying to
copy formulas from workbook to another without carrying over the link Dave's
method does work

--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;jacobquot; gt; wrote in message
...
gt; This did not work for copying and replacing a whole page.
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt;gt; Select the range to copy
gt;gt; Edit|replace
gt;gt; what: = (equal sign)
gt;gt; with: $$$$$
gt;gt; replace all
gt;gt;
gt;gt; copy and paste these text strings to where you want them.
gt;gt;
gt;gt; Then select that pasted range
gt;gt; edit|replace
gt;gt; what: $$$$$
gt;gt; with: =
gt;gt; replace all
gt;gt;
gt;gt; Now the text strings are converted back to formulas.
gt;gt;
gt;gt; Don't forget to fix the original range, too.
gt;gt;
gt;gt; jacob wrote:
gt;gt; gt;
gt;gt; gt; What if the whole page is full of formulas? Like 100 of them?
gt;gt; gt;
gt;gt; gt; Thanks!
gt;gt; gt;
gt;gt; gt; quot;Kevin Bquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; You can copy the formula out of the formula bar, or you can press F2
gt;gt; gt; gt; and copy
gt;gt; gt; gt; the formula from inside the cell, but in either case, select
gt;gt; gt; gt; everything in
gt;gt; gt; gt; the formula excluding the quot;=quot;. You can then paste the formula into
gt;gt; gt; gt; your
gt;gt; gt; gt; target workbook by moving to the target cell, typing an equal sign
gt;gt; gt; gt; and
gt;gt; gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt;gt; gt; gt; --
gt;gt; gt; gt; Kevin Backmann
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; quot;jacobquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt; Is there a way to copy and page formulas from one workbook to
gt;gt; gt; gt; gt; another without
gt;gt; gt; gt; gt; it trying to link the pages to the original workbook? I pasted
gt;gt; gt; gt; gt; pages and
gt;gt; gt; gt; gt; some of the formulas without my knowledge were linked.
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Dave Peterson
gt;gt;
Sorry guys, i must not understand....

When i select the region i want to copy which is the whole worksheet and
press Edit on the menu bar and Replace, All i get is a dialog box that asks
quot;Find What:quot; and quot;Rreplace With:quot; It doesn't allow me to copy the whole
page from one book to the next or one sheet to the next.

Even if i place an equal sign in the text box or drop down box and then
select the whole workseet, I still don't get anything.

Maybe I need a few more details.

I'm using MS Office 2003

Thanks!
quot;Peo Sjoblomquot; wrote:

gt; Either Dave misunderstood or you did it incorrectly, if you are trying to
gt; copy formulas from workbook to another without carrying over the link Dave's
gt; method does work
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt; quot;jacobquot; gt; wrote in message
gt; ...
gt; gt; This did not work for copying and replacing a whole page.
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt;gt; Select the range to copy
gt; gt;gt; Edit|replace
gt; gt;gt; what: = (equal sign)
gt; gt;gt; with: $$$$$
gt; gt;gt; replace all
gt; gt;gt;
gt; gt;gt; copy and paste these text strings to where you want them.
gt; gt;gt;
gt; gt;gt; Then select that pasted range
gt; gt;gt; edit|replace
gt; gt;gt; what: $$$$$
gt; gt;gt; with: =
gt; gt;gt; replace all
gt; gt;gt;
gt; gt;gt; Now the text strings are converted back to formulas.
gt; gt;gt;
gt; gt;gt; Don't forget to fix the original range, too.
gt; gt;gt;
gt; gt;gt; jacob wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; What if the whole page is full of formulas? Like 100 of them?
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks!
gt; gt;gt; gt;
gt; gt;gt; gt; quot;Kevin Bquot; wrote:
gt; gt;gt; gt;
gt; gt;gt; gt; gt; You can copy the formula out of the formula bar, or you can press F2
gt; gt;gt; gt; gt; and copy
gt; gt;gt; gt; gt; the formula from inside the cell, but in either case, select
gt; gt;gt; gt; gt; everything in
gt; gt;gt; gt; gt; the formula excluding the quot;=quot;. You can then paste the formula into
gt; gt;gt; gt; gt; your
gt; gt;gt; gt; gt; target workbook by moving to the target cell, typing an equal sign
gt; gt;gt; gt; gt; and
gt; gt;gt; gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt; gt;gt; gt; gt; --
gt; gt;gt; gt; gt; Kevin Backmann
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; quot;jacobquot; wrote:
gt; gt;gt; gt; gt;
gt; gt;gt; gt; gt; gt; Is there a way to copy and page formulas from one workbook to
gt; gt;gt; gt; gt; gt; another without
gt; gt;gt; gt; gt; gt; it trying to link the pages to the original workbook? I pasted
gt; gt;gt; gt; gt; gt; pages and
gt; gt;gt; gt; gt; gt; some of the formulas without my knowledge were linked.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Dave Peterson
gt; gt;gt;
gt;
gt;
gt;

When you get that dialogue box, put the equal sign in the find what box,
then in the replace with box put the unique string like $$$$$$ or ^^^^ or
something that does not normally occurs, do the replace by clicking replace
all, THEN copy everything to the new. Then in both sheets do a reverse
replace and replace the $$$$$ with =

done
--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;jacobquot; gt; wrote in message
...
gt; Sorry guys, i must not understand....
gt;
gt; When i select the region i want to copy which is the whole worksheet and
gt; press Edit on the menu bar and Replace, All i get is a dialog box that
gt; asks
gt; quot;Find What:quot; and quot;Rreplace With:quot; It doesn't allow me to copy the whole
gt; page from one book to the next or one sheet to the next.
gt;
gt; Even if i place an equal sign in the text box or drop down box and then
gt; select the whole workseet, I still don't get anything.
gt;
gt; Maybe I need a few more details.
gt;
gt; I'm using MS Office 2003
gt;
gt; Thanks!
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Either Dave misunderstood or you did it incorrectly, if you are trying to
gt;gt; copy formulas from workbook to another without carrying over the link
gt;gt; Dave's
gt;gt; method does work
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; nwexcelsolutions.com
gt;gt;
gt;gt;
gt;gt; quot;jacobquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; This did not work for copying and replacing a whole page.
gt;gt; gt;
gt;gt; gt; quot;Dave Petersonquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Select the range to copy
gt;gt; gt;gt; Edit|replace
gt;gt; gt;gt; what: = (equal sign)
gt;gt; gt;gt; with: $$$$$
gt;gt; gt;gt; replace all
gt;gt; gt;gt;
gt;gt; gt;gt; copy and paste these text strings to where you want them.
gt;gt; gt;gt;
gt;gt; gt;gt; Then select that pasted range
gt;gt; gt;gt; edit|replace
gt;gt; gt;gt; what: $$$$$
gt;gt; gt;gt; with: =
gt;gt; gt;gt; replace all
gt;gt; gt;gt;
gt;gt; gt;gt; Now the text strings are converted back to formulas.
gt;gt; gt;gt;
gt;gt; gt;gt; Don't forget to fix the original range, too.
gt;gt; gt;gt;
gt;gt; gt;gt; jacob wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; What if the whole page is full of formulas? Like 100 of them?
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Thanks!
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; quot;Kevin Bquot; wrote:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; gt; You can copy the formula out of the formula bar, or you can press
gt;gt; gt;gt; gt; gt; F2
gt;gt; gt;gt; gt; gt; and copy
gt;gt; gt;gt; gt; gt; the formula from inside the cell, but in either case, select
gt;gt; gt;gt; gt; gt; everything in
gt;gt; gt;gt; gt; gt; the formula excluding the quot;=quot;. You can then paste the formula
gt;gt; gt;gt; gt; gt; into
gt;gt; gt;gt; gt; gt; your
gt;gt; gt;gt; gt; gt; target workbook by moving to the target cell, typing an equal sign
gt;gt; gt;gt; gt; gt; and
gt;gt; gt;gt; gt; gt; pressing Ctrl V to paste the text of the formula into the cell.
gt;gt; gt;gt; gt; gt; --
gt;gt; gt;gt; gt; gt; Kevin Backmann
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; quot;jacobquot; wrote:
gt;gt; gt;gt; gt; gt;
gt;gt; gt;gt; gt; gt; gt; Is there a way to copy and page formulas from one workbook to
gt;gt; gt;gt; gt; gt; gt; another without
gt;gt; gt;gt; gt; gt; gt; it trying to link the pages to the original workbook? I pasted
gt;gt; gt;gt; gt; gt; gt; pages and
gt;gt; gt;gt; gt; gt; gt; some of the formulas without my knowledge were linked.
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt;
gt;gt; gt;gt; Dave Peterson
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;