How to auto transfer data from sheet A to sheet B

Posts
3
Registration date
Wednesday August 8, 2018
Last seen
August 9, 2018
-
Hello,

pls teach me how to autotransfer data from "sheet 1" to other sheet "IAS2901" "IAS2902"... follow by the code in "sheet 1". this sheet1 data will update from time to time, would data autotransfer everytime i key in.

tq very much
from kevin





See more 

Your reply

3 replies

Posts
10940
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
0
Thank you
Greetings,

Please, bare in mind that CCM.net is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Hence we request that CCM forum users show mutual respect. We need you to provide the code, and we can help. We do not provide turn key solutions. We help when YOU are stuck.

Being courteous will increase your chances of getting the help you need.

http://ccm.net/contents/948-terms-of-use-for-ccm-respect-for-others

Please, copy, modify and repost your message respecting the charter.

We trust that you understand.
gcf77
Posts
3
Registration date
Wednesday August 8, 2018
Last seen
August 9, 2018
-
good morning, i m so sorry if i break the term of use. i had try on this issues by using function build-in excel, but then built-in function unable to fulfill. then i get know on macro, try to learn it but still fresh, if can reverse trace back the source code then i will able to learn more faster. there are 4 coloum i need to transfer, but only ask 2 coloum bcoz i hope to solve other 2 by myself, at least i still can learn to write something. anyway thank you ac3mark. :)
Respond to ac3mark
Posts
1207
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
December 15, 2018
0
Thank you
Hello Gcf77,

See if the macro code at the following link helps:-

https://ccm.net/forum/affich-1020851-autopopulating-multiple-sheets-from-one-main-sheet

The link to the sample file in the above link still works so have a look at it also and see what you think. Click on the "UPDATE" button to see how it works. You'll notice that the data for each individual mentioned in Column C is transferred to the individual's sheet.

If its what you would like to do with your own file, then let us know and we can help you adapt it to your workbook. Experiment with it yourself first.

I hope that this helps.

Cheerio,
vcoolio.
gcf77
Posts
3
Registration date
Wednesday August 8, 2018
Last seen
August 9, 2018
-
TQ Cheerio, this should be able to solve most of my question. i will study and digest first, any question will ask again. tq tq
Respond to vcoolio
Posts
1207
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
December 15, 2018
0
Thank you
Good on you gcf77. Come back any time should you have any further questions or need clarification with any aspect.

Cheerio,
vcoolio.
Respond to vcoolio