Re: How do I use references to another work*** when new rows are

From: BryanL (BryanL_at_discussions.microsoft.com)
Date: 08/10/04 

Date: Tue, 10 Aug 2004 14:17:03 -0700

Frank,
Thanks for the response.
The previous work*** is a competitor price listing for 2004 and we are
looking at new prices from their 2005 catalog. The '2004'! reference is used
in a nested If formula along these incorrect syntax lines: if (isblank(test
cell),"",if(2005 price=2004 price),"",2005 price - 2004 price). Basically
tracking any price changes since 2004. The problem is 2005 product line has
increased and new rows must be added.
In past times, Quattro Pro allowed the "worksheets" to be manually grouped
and any row insertions were "mirrored" with each other.
Regards,
BryanL
"Frank Kabel" wrote:

> Hi
> what exact formula are you currently using and what would be your
> expected result of this formula after inserting a row
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> BryanL wrote:
> > I'm referencing cells in a work*** and updating items in a new
> > work*** (which is a copy at first) of that work***. Along the
> > way we need to insert new rows to allow changes in product line but
> > the original (or referenced work***) stays the same. The formula
> > reference is therefore disrupted. Is there a workaround?
>
>

Quantcast