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