Link to range of cells, so formulas are retained

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?
 
Have tried to copy range of cells containing formulas, to another worksheet,
but can only manage to save values only by 'paste special'. The formulas
lose their links and display REF!
What I want to do is copy the whole range, retaining the links in the
process. This would be the equivalent of entering a formula in each
dependent cell and linking to the corresponding cell in the source worksheet.

Is it possible to do this across multiple cells (a range) in one go?
Click to expand...

Somewhere, but I cannot find it tonight, there's a way to change ALL
nunber in a worksheet to Absolute ( with the $ sign in front). Then
when you copy they don't change. If you want them dynnamic again you
can use the Find menu / Find / Replace and put $ in the Find window
and leave the Replace With window blank. The Find Replace won't work
when there's nothing but a blank space to change.

ed
 
ed said:
Somewhere, but I cannot find it tonight, there's a way to change
ALL nunber in a worksheet to Absolute ( with the $ sign in
front).
Click to expand...

Gord Dibben just posted his macros to do this. They are in
this group, findable with the following information from that
article:

From: Gord Dibben <gorddibbATshawDOTca>
Subject: Re: Changing all formulae in a worksheet from absolute to relative
Date: Mon, 23 Jul 2007 15:48:57 -0700
Message-ID: <[email protected]>

(They look good to me; I've saved them for future reference. Thanks,
Gord!)

Dallman
 
One method.....................

Edit>Replace

What: =

With: ^^^

Replace all.

Copy the range to the other worksheet and reverse the process.


Gord Dibben MS Excel MVP
 
Back
Top