+ Reply to Thread
Results 1 to 12 of 12

Help auto transfer data using Macro

  1. 01-20-2018, 07:01 AM #1
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Help auto transfer data using Macro

    Dear All expert

    How to transfer data using macro with button box?

    And if DataEntry with number 2 it will be transfered in Sheet 2


    Regard

    File update in Post#3
    Attached Files Attached Files
    Last edited by xymcrush17; 01-20-2018 at 10:43 AM.
    Reply With QuoteRegister To Reply
  2. 01-20-2018, 07:40 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    Perhaps...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 01-20-2018, 10:23 AM #3
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Re: Help auto transfer data using Macro

    It works perfect,

    But Im Sorry, I forget that Number maybe fill with "2/NR/I/2018"

    And I edited my expected file attachment
    Attached Files Attached Files
    Last edited by xymcrush17; 01-20-2018 at 10:42 AM.
    Reply With QuoteRegister To Reply
  4. 01-20-2018, 12:18 PM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    It works perfect,
    If above is true then why request further help...
    In future please update a sample file with exact scenario so that no time is wasted with unnecessary incorrect code...
    This should work...
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 01-20-2018, 12:39 PM #5
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Re: Help auto transfer data using Macro

    If i Try to add NUMBER 100/NR/I/2018
    it will be copied to sheet 1, that should be copied to sheet 100
    Reply With QuoteRegister To Reply
  6. 01-20-2018, 12:59 PM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    Replace 
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 01-20-2018, 01:20 PM #7
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Re: Help auto transfer data using Macro

    Quote Originally Posted by sintek View Post
    Replace 
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.

    If i try to add more column as string for example in column G
    add will be copied to F20, this code does not work
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 01-20-2018, 01:45 PM #8
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    please do not quote whole posts, it just clutters the thread...
    Please Login or Register  to view this content.
    Not sure what you are trying to achieve...Upload a new sample with your new criteria and new expected results...
    Reply With QuoteRegister To Reply
  9. 01-20-2018, 01:55 PM #9
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Re: Help auto transfer data using Macro

    I just add new column
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 01-20-2018, 02:01 PM #10
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    Your upload makes no sense...Upload depicting required result...
    Reply With QuoteRegister To Reply
  11. 01-20-2018, 02:11 PM #11
    xymcrush17
    xymcrush17 is offline
    Registered User
    Join Date
    02-26-2015
    Location
    Jakarta, Indonesia
    MS-Off Ver
    2007
    Posts
    33

    Re: Help auto transfer data using Macro

    Im Sorry
    I mean I want the filter result "20/01/2018" that is copied in "F20"
    Reply With QuoteRegister To Reply
  12. 01-20-2018, 02:18 PM #12
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,236

    Re: Help auto transfer data using Macro

    nope still don't get it...see post 10
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto transfer data from one column to another
    By thomasrepair in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2016, 01:06 AM
  2. Auto transfer data from one tab to another the graphs and auto update
    By Elsa_Lion22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2014, 02:15 PM
  3. Excel 2007 : Auto transfer of data from one sheet to another
    By SSDGEEK in forum Excel General
    Replies: 2
    Last Post: 06-21-2011, 11:07 AM
  4. auto-transfer data
    By rajat20001 in forum Excel General
    Replies: 12
    Last Post: 04-20-2009, 12:03 AM
  5. [SOLVED] Auto Data Transfer
    By Freshman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-29-2006, 12:55 AM
  6. Auto Data Transfer
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-28-2006, 11:55 PM
  7. Auto Data Transfer
    By KRAMER in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2005, 02:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1