Pasting Formulas
 

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.

Pasting Formulas
 

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 "=". 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 Backmann


"jacob" wrote:

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.

Pasting Formulas
 

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

Pasting Formulas
 

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson

Pasting Formulas
 

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

"Dave Peterson" wrote:

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson

Pasting Formulas
 

Which part didn't work?

And you selected all the cells first?

jacob wrote:

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

"Dave Peterson" wrote:

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson


--

Dave Peterson

Pasting Formulas
 

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

http://nwexcelsolutions.com


"jacob" wrote in message
...
This did not work for copying and replacing a whole page.

"Dave Peterson" wrote:

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson

Pasting Formulas
 

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
"Find What:" and "Rreplace With:" 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!
"Peo Sjoblom" wrote:

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

http://nwexcelsolutions.com


"jacob" wrote in message
...
This did not work for copying and replacing a whole page.

"Dave Peterson" wrote:

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson

Pasting Formulas
 

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

http://nwexcelsolutions.com


"jacob" wrote in message
...
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
"Find What:" and "Rreplace With:" 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!
"Peo Sjoblom" wrote:

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

http://nwexcelsolutions.com


"jacob" wrote in message
...
This did not work for copying and replacing a whole page.

"Dave Peterson" wrote:

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:

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

Thanks!

"Kevin B" wrote:

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 "=". 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 Backmann


"jacob" wrote:

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.

--

Dave Peterson