Dynamic Range Selection

[Dedes]

Hi,

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

I have attached a file to help understand my issue and I will try to describe the best I can what's going on.

Suppose I have a mtrix - 5x5 matrix - and I have given a name to the centre values - centre - to the upper values - up - and to the lower values - down. You can check these names onthe file attached.

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.

Is this possible?

thanks
Dedes

PS - I have put this question also on this forum:

http://www.mrexcel.com/forum/showthr...47#post2741047

[jeffreybrown]

I think this question is above my knowledge level, but...

Please take a few minutes and read the Forum Rules about cross posts.

Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.

It is preferred that you not cross-post at all, but if you do, please provide a link to the cross-post