Hi,

I want to use a macro or a simple formula, it doesn't matter which, and have
the result remain the same, even though week on week the cells in the formula
will change value.

This is because each week I will have a different column using the same
formula as the column before it but the result will be different each time
because the data in the formula will change each week. However I need the
results in each progressive week's column to remain the same.

Is there a way of doing this?
Thanks