Transfer data from sheet A to Sheet B
 

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
------------------------------------------------------------------------------
---------------------------
"678" a b d
b a b
c d c
d c a
------------------------------------------------------------------------------
---------------------------
"912"
------------------------------------------------------------------------------
---------------------------
"234"
------------------------------------------------------------------------------
---------------------------
"567"
------------------------------------------------------------------------------
---------------------------
"890"

Transfer data from sheet A to Sheet B
 

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" <u38139@uwe wrote in message news:798047d516fa3@uwe...
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
------------------------------------------------------------------------------
---------------------------
"678" a b d
b a b
c d c
d c a
------------------------------------------------------------------------------
---------------------------
"912"
------------------------------------------------------------------------------
---------------------------
"234"
------------------------------------------------------------------------------
---------------------------
"567"
------------------------------------------------------------------------------
---------------------------
"890"

Transfer data from sheet A to Sheet B
 

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

Zenmeup wrote:
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
------------------------------------------------------------------------------

"678" a b d
b a b
c d c
d c a
------------------------------------------------------------------------------

"912"
------------------------------------------------------------------------------

"234"
------------------------------------------------------------------------------

"567"
------------------------------------------------------------------------------

"890"

--
Message posted via http://www.officekb.com