Problems with transferring data into different columns in a workbo
 

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 questions a
- 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)? The
results (data) should come up in different columns for week 36, 37, 38 and so
on. Are there any formulas or macros that I need to put in? What function
should I use, or what should I type in as a macro?

Thank you very much!

Problems with transferring data into different columns in a workbo
 

Bjørn,

See my solution in other news group.

Regards,
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 questions a
- 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)? The
results (data) should come up in different columns for week 36, 37, 38 and
so
on. Are there any formulas or macros that I need to put in? What function
should I use, or what should I type in as a macro?

Thank you very much!