Prev: alphabetize worksheet names
Next: vlookup for max value or any value>0
From: ksell87 on 13 May 2010 15:54
File One.xls contains cells that pull information (i.e. a percentage of some
number) from Two.xls. I want to be able to update information (the
percentage) in Two.xls, then go back into One.xls and have the previous
information stay the same (using the old percentage) and have any new data
use the updated percentage.

Any ideas?
From: Gord Dibben on 13 May 2010 19:13
Sounds like you are dealing with linking formulas.

As long as they remain formulas they will update with any change of data in
Two.xls

You must copy and paste special values which destroys the formulas unless
you copy and paste to a new range.

I think you will have to use VBA event code.


Gord Dibben MS Excel MVP

On Thu, 13 May 2010 12:54:01 -0700, ksell87
<ksell87(a)discussions.microsoft.com> wrote:

>File One.xls contains cells that pull information (i.e. a percentage of some
>number) from Two.xls. I want to be able to update information (the
>percentage) in Two.xls, then go back into One.xls and have the previous
>information stay the same (using the old percentage) and have any new data
>use the updated percentage.
>
>Any ideas?

 | 
Pages: 1
Prev: alphabetize worksheet names
Next: vlookup for max value or any value>0