See

http://cpearson.com/excel/named.htm#Dynamic


In article <1134999419.005534.206340@g44g2000cwa.googlegroups.com>,
madhavansaju@gmail.com wrote:

> Hi,
>
> I have a named range (Euro_Calc). This contains some columns with data
> and others with formulae. These formulae also use the "Euro_Calc"
> range.
> All these are used to create some reports.
>
> Each week, I need to create a new report with fresh data. However the
> number of rows vary each week.
>
> I would like to paste the new data into the sheet (into the data
> columns) - and the named range should now refer to new number of rows.
> The columns with formulae should also be copied down to the last row.
>
> Is this possible with a simple copy/paste or
> Is this possible with VBA macro?
>
> Thanks in advance