Hi all,

Is there any possibility that multiple cells are linked to one cell and
applying the same formula with column or row increament and modified
autometically as orignal cells formula change, for example

In A5 formula is: =Sum(A1:A4)
In B5 (which is required to be linked with A5) has fomula bse on A5 formula
with column increament i.e. =Sum(B1:B4)

I need to know that if there is any possibility that when i change the range
of formula in cell A5 (for example from =sum(a1:a4) to =sum(a1:a3)) the cell
B5 autometically incorporate the change and modified its own formula (from
=sum(b1:b4) to =sum(b1:b3))

If there would be any possibility than it would be really helpful

Just hazarding a guess here ...
Maybe something like this is what you're after?

Let's say you have a defined "base" range: MyR
which refers to: =Sheet1!$A$1:$A$4

Then you have this placed in Sheet1's A5:
=SUM(OFFSET(MyR,,COLUMNS($A:A)-1))
[ the above's the same as the much simpler: =SUM(A1:A4) ]

And you copy A5 across to B5, C5 etc to return the corresponding sums, all
of which are pegged to MyR.

If you have the above set-up, you could then amend MyR's range "centrally"
via clicking Insert Name Define, and adjust it to refer to say:
=Sheet1!$A$1:$A$3 instead. And when you do so, all the formulas in A5, B5, C5
etc would then adjust automatically to refer to the shortened range.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Flawlesgem" wrote:
Is there any possibility that multiple cells are linked to one cell and
applying the same formula with column or row increament and modified
autometically as orignal cells formula change, for example

In A5 formula is: =Sum(A1:A4)
In B5 (which is required to be linked with A5) has fomula bse on A5 formula
with column increament i.e. =Sum(B1:B4)

I need to know that if there is any possibility that when i change the range
of formula in cell A5 (for example from =sum(a1:a4) to =sum(a1:a3)) the cell
B5 autometically incorporate the change and modified its own formula (from
=sum(b1:b4) to =sum(b1:b3))

If there would be any possibility than it would be really helpful

The solution is perfect to what i am looking for
One more thing wat if the formula in the cell not refer to any range, only
just refer to two individual cells like =A1*A4

"Max" wrote:

Just hazarding a guess here ...
Maybe something like this is what you're after?

Let's say you have a defined "base" range: MyR
which refers to: =Sheet1!$A$1:$A$4

Then you have this placed in Sheet1's A5:
=SUM(OFFSET(MyR,,COLUMNS($A:A)-1))
[ the above's the same as the much simpler: =SUM(A1:A4) ]

And you copy A5 across to B5, C5 etc to return the corresponding sums, all
of which are pegged to MyR.

If you have the above set-up, you could then amend MyR's range "centrally"
via clicking Insert Name Define, and adjust it to refer to say:
=Sheet1!$A$1:$A$3 instead. And when you do so, all the formulas in A5, B5, C5
etc would then adjust automatically to refer to the shortened range.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---
"Flawlesgem" wrote:
Is there any possibility that multiple cells are linked to one cell and
applying the same formula with column or row increament and modified
autometically as orignal cells formula change, for example

In A5 formula is: =Sum(A1:A4)
In B5 (which is required to be linked with A5) has fomula bse on A5 formula
with column increament i.e. =Sum(B1:B4)

I need to know that if there is any possibility that when i change the range
of formula in cell A5 (for example from =sum(a1:a4) to =sum(a1:a3)) the cell
B5 autometically incorporate the change and modified its own formula (from
=sum(b1:b4) to =sum(b1:b3))

If there would be any possibility than it would be really helpful

"Flawlesgem" wrote:
The solution is perfect to what i am looking for

Welcome. Pl take a moment to rate that earlier response. Go back and click
the Yes button (like the one below). Thanks.

One more thing what if the formula in the cell not refer to any range, only
just refer to two individual cells like =A1*A4

I suppose you mean a discontiguous range?
Still possible to define such, eg:
MyR: =Sheet1!$A$1,Sheet1!$A$4
but it may not work as expected, unlike the earlier contiguous range
You could try tinkering around with it

Ditto for a single cell defined range, eg:
MySingleR: =Sheet1!$A$1

If you mean operate likewise w/o using a defined range, I don't know.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---

Thanks alot, and will take care next time to rate the post

Regards





"Max" wrote:

"Flawlesgem" wrote:
The solution is perfect to what i am looking for

Welcome. Pl take a moment to rate that earlier response. Go back and click
the Yes button (like the one below). Thanks.

One more thing what if the formula in the cell not refer to any range, only
just refer to two individual cells like =A1*A4

I suppose you mean a discontiguous range?
Still possible to define such, eg:
MyR: =Sheet1!$A$1,Sheet1!$A$4
but it may not work as expected, unlike the earlier contiguous range
You could try tinkering around with it

Ditto for a single cell defined range, eg:
MySingleR: =Sheet1!$A$1

If you mean operate likewise w/o using a defined range, I don't know.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:363 Subscribers:64
xdemechanik
---

Welcome, thanks.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:362 Subscribers:64
xdemechanik
---
"Flawlesgem" wrote in message
...
Thanks alot, and will take care next time to rate the post