Fixed column- Variable row #
 

I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of values.

I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.

What I need is to be able to name another cell using cell B8 as a part of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell B8(=24;
today...)
as its' row #.

Fixed column- Variable row #
 

Hi

If you want to name cell Y29 given your value in B8 then you can use
INDEX:

Go InsertNameDefine and name the cell whatever you want, and in the
refers to box type:

=INDEX($Y:$Y,$B$8+5)

This will specify Y29 today (the +5 modifies the B8 value) and
tomorrow, the name will refer to Y30 as the B8 value increments.

Hope this helps!

Richard

Vasilis Tergen wrote:

I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of values.

I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.

What I need is to be able to name another cell using cell B8 as a part of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell B8(=24;
today...)
as its' row #.

Fixed column- Variable row #
 

Sir,
Thank you for the answer. Unfortunately, the question was posed erroneously.
The proper, entire question appears in this discussion forum under:
"Fixed column, variable rows" and is of yet unanswered.

"RichardSchollar" wrote:

Hi

If you want to name cell Y29 given your value in B8 then you can use
INDEX:

Go InsertNameDefine and name the cell whatever you want, and in the
refers to box type:

=INDEX($Y:$Y,$B$8+5)

This will specify Y29 today (the +5 modifies the B8 value) and
tomorrow, the name will refer to Y30 as the B8 value increments.

Hope this helps!

Richard

Vasilis Tergen wrote:

I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of values.

I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.

What I need is to be able to name another cell using cell B8 as a part of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell B8(=24;
today...)
as its' row #.

Fixed column- Variable row #
 

Not in *this* group. Perhaps you are referring to your message in
news:microsoft.public.excel.programming ?
--
David Biddulph

"Vasilis Tergen" wrote in message
...
Sir,
Thank you for the answer. Unfortunately, the question was posed
erroneously.
The proper, entire question appears in this discussion forum under:
"Fixed column, variable rows" and is of yet unanswered.

"RichardSchollar" wrote:

Hi

If you want to name cell Y29 given your value in B8 then you can use
INDEX:

Go InsertNameDefine and name the cell whatever you want, and in the
refers to box type:

=INDEX($Y:$Y,$B$8+5)

This will specify Y29 today (the +5 modifies the B8 value) and
tomorrow, the name will refer to Y30 as the B8 value increments.

Hope this helps!

Richard

Vasilis Tergen wrote:

I need to name a cell, using a fixed column and a a variable row #.
The row # changes every day, and it is the last row of a column of
values.

I have the needed row #, resulting as a value in cell B8.
Ex: Today: B8=24. Tomorrow: B8 will be equal to: 25...
Thus, cell B8, will always point to the row # needed= the last row #
containing values.

What I need is to be able to name another cell using cell B8 as a part
of a
formula.
Ex: If I wanted to name cell Y29, I'd want to use the value of cell
B8(=24;
today...)
as its' row #.