How to auto transfer data from sheet A to sheet B

gcf77 3 Posts Wednesday August 8, 2018Registration date August 9, 2018 Last seen - Aug 8, 2018 at 04:14 AM - Latest reply: vcoolio 1200 Posts Thursday July 24, 2014Registration dateModeratorStatus October 12, 2018 Last seen
- Aug 9, 2018 at 09:22 PM
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

5 replies

ac3mark 10668 Posts Monday June 3, 2013Registration dateModeratorStatus October 17, 2018 Last seen - Aug 8, 2018 at 05:30 PM
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 3 Posts Wednesday August 8, 2018Registration date August 9, 2018 Last seen - Aug 8, 2018 at 09:32 PM
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
vcoolio 1200 Posts Thursday July 24, 2014Registration dateModeratorStatus October 12, 2018 Last seen - Aug 9, 2018 at 06:23 AM
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 3 Posts Wednesday August 8, 2018Registration date August 9, 2018 Last seen - Aug 9, 2018 at 09:30 AM
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
vcoolio 1200 Posts Thursday July 24, 2014Registration dateModeratorStatus October 12, 2018 Last seen - Aug 9, 2018 at 09:22 PM
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