Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transfer certain data from Sheet 1 to sheet 2 | Excel Worksheet Functions | |||
Transfer cell data from sheet to sheet? | Excel Discussion (Misc queries) | |||
How can I transfer a required data from sheet 1 to sheet 2 automat | Excel Discussion (Misc queries) | |||
how to transfer data from sheet to sheet with new range? | Excel Discussion (Misc queries) | |||
How to Automatically transfer specific Data from Sheet 1 to Sheet | Excel Worksheet Functions |