Dynamically Changing Named Ranges
 

I have a model that has hours worked by person by period. Today's
date looking back is actuals and today's date looking forward is a
forecast. What I need to do is provide a cum total of hours worked to
date (omitting forecasting).

I've done it before, but my brain is fried - so help would be great.
What I'd like to do is create a named dynamic range that expands based
on date change.

i.e.

Today 12/15/07

Col - A B C D
Row
I
1 12/07 12/14 12/21 12/28
2 John 5 4 3 5
3 Bill 1 2 2 1
4 Adam 3 4 4 2

sumif(a1:today) basically......

Thanks..help is tremendously appreciated. Probably use indirects and
matchs..but can't think anymore.

v/r

PAZ

Dynamically Changing Named Ranges
 

try it

http://www.ozgrid.com/Excel/DynamicR...OhMa+wLs+i7KkR

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



" escreveu:

I have a model that has hours worked by person by period. Today's
date looking back is actuals and today's date looking forward is a
forecast. What I need to do is provide a cum total of hours worked to
date (omitting forecasting).

I've done it before, but my brain is fried - so help would be great.
What I'd like to do is create a named dynamic range that expands based
on date change.

i.e.

Today 12/15/07

Col - A B C D
Row
I
1 12/07 12/14 12/21 12/28
2 John 5 4 3 5
3 Bill 1 2 2 1
4 Adam 3 4 4 2

sumif(a1:today) basically......

Thanks..help is tremendously appreciated. Probably use indirects and
matchs..but can't think anymore.

v/r

PAZ

Dynamically Changing Named Ranges
 

On Dec 17, 1:01 pm, Marcelo wrote:
try it

http://www.ozgrid.com/Excel/DynamicR...6=166B28A37!Rk...

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo

" escreveu:



I have a model that has hours worked by person by period. Today's
date looking back is actuals and today's date looking forward is a
forecast. What I need to do is provide a cum total of hours worked to
date (omitting forecasting).

I've done it before, but my brain is fried - so help would be great.
What I'd like to do is create a named dynamic range that expands based
on date change.

i.e.

Today 12/15/07

Col - A B C D
Row
I
1 12/07 12/14 12/21 12/28
2 John 5 4 3 5
3 Bill 1 2 2 1
4 Adam 3 4 4 2

sumif(a1:today) basically......

Thanks..help is tremendously appreciated. Probably use indirects and
matchs..but can't think anymore.

v/r

PAZ- Hide quoted text -

- Show quoted text -

Thanks! I saw this during searches..but didn't pay close enough
attention..this should do the trick.