How to auto transfer data from sheet A to sheet B

Closed
gcf77 Posts 3 Registration date Wednesday August 8, 2018 Status Member Last seen August 9, 2018 - Updated on Aug 8, 2018 at 04:19 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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





3 responses

Blocked Profile
Aug 8, 2018 at 05:30 PM
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.

https://ccm.net/apps-sites/internet-archeology/ccm/10131-terms-of-use-for-ccm-respect-for-others/

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

We trust that you understand.
0
gcf77 Posts 3 Registration date Wednesday August 8, 2018 Status Member Last seen August 9, 2018
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. :)
0
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Aug 9, 2018 at 06:23 AM
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.
0
gcf77 Posts 3 Registration date Wednesday August 8, 2018 Status Member Last seen August 9, 2018
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
0
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 262
Aug 9, 2018 at 09:22 PM
Good on you gcf77. Come back any time should you have any further questions or need clarification with any aspect.

Cheerio,
vcoolio.
0