Transfer data from sheet A to Sheet B

[Zenmeup]

Transfer data from sheet A to Sheet B

Depending on the actual week and the username I would like to transfer data
from Sheet A to Sheet B.
For example: input from user(name) "123" in Sheet A cells d5:d8 need to be
copied to row username "123" to the next empty column in Sheet B.
30 users need to fill Sheet A cells d5:d8. Each time a new user adds data in
Sheet A data will be transfered to Sheet B. Need a Visual Basic code to do
the action.
Thanks in advance.

Results Sheet B

User Week 41 42 43 44 etc.
"123" a b d
b a b
c d c
d c a
------------------------------------------------------------------------------
---------------------------
"345" a b d
b a b
c d c
d c a
------------------------------------------------------------------------------

 

[Clinton M James]

Can you please provide more details, such as where in Sheet A do they enter
their username? - what do you need to happen to the username once they have
entered - cleared again or does Sheet A keep the username and the next user
enters their name under?


I presume sheet a is for data entry only and sheet b logs a historical view?

Regards,
Clint

 

[Zenmeup via OfficeKB.com]

Hello Clint,

In sheet A input in cell B1 = username (will be always updated)
In sheet A input in cell C1 = actual weeknummber (will be always updated)

Thanks