Data Range

[Patrik Karlstrom]

Hello,

I'm sitting here with a large number of Excel Graphs. I am [VERY] slowly
getting into Dyn Named Ranges, but I'm not there yet. So please don't go
ahead and explain in extended details how I will go about solving my problem
with that. It is a very interesting subject, but I have no time for now to
get into this new field. I need to solve my problem of the ranges expanding
when I insert a new row for a new week. I need to keep the range to the
following 12 weeks below the first cell and don't expand the range when I
insert a new row.

For now the range could be: Source Data - Data Range: ='SHEET
NAME'!$T$5:$U$18.

Any suggestion to prevent that the range expands to $T$4:$U$18 when I insert
a new row is very welcome. The T column is the dates and the U column is
the sales amounts, and when I insert a new week I want the range to become
$T$4:$U$17. Something have to be done about the Absolute Cell References,
but I don't know what.

Anyone? Thanks in advance!!

Patrik

 

[duane]

maybe im missing something but how can your range expand as described b
inserting a row? the insertion should change row 18 to row 19, and ro
5 remain unchanged

 

[Patrik Karlstrom]

Still there? You're right. That is what I'm trying to prevent. I only
want to have the 12 following weeks under the first cell. I don't want it
to expand.

Patrik