Help with dynamic ranges

[Dedes]

Hi,

I would like to ask for some help with a problem I am having:

Suppose I have a mtrix - 5x5 matrix - and I have given a name to the centre values - c- to the upper values - u - and to the lower values - d.

Something like this

c u u u u
d c u u u
d d c u u
d d d c u
d d d d c

Now, on top I have a score. At the moment is 0-0. But if it goes to 1-0 the diference would be 1. And what I want when this happens is to change the ranges. On this case - diference of 1 - each center cell would will move one row down. The up cells would now be the up cells plus the centre cell when the score was 0-0. And the down cells would be reduced by what is now the centre cells. So it woud look like this

u u u u u
c u u u u
d c u u u
d d c u u
d d d c u

Is this possible?

thanks
Dedes

 

[Dedes]

Just wanted to add that I have also put this question here:

http://www.excelforum.com/excel-programming/778729-dynamic-range-selection.html#post2538425