Hi

I think you should use a macro to do this. The macro can be called from a
button on the source sheet.

If you need help writing the macro, ´more information about where to find
the source data and in where the first column of data should be stored.

HTH
Per

"Bjørn" skrev i meddelelsen
...
1) You have a source-list in sheet no. 1.
2) Sheet no 2, 3, 4.... 16 are sheets where the datas are going in when
you
write them in the cells in the source list (sheet no.1).
3) The source-list should be used for the same purpose every week. The
other
15 sheets are each containing one row for week 36, then week 37, 38, 39
and
so on. The results that you put in the source-sheet should come up in the
right row every week.

My question is:
- How will I be able to use the same source-list every week to register
the
data only by changing the weekly number in sheet 1 (Source sheet). Are
there
any formulas that I need to put in?

Thank you very much!