+ Reply to Thread
Results 1 to 5 of 5

Transfer data from input sheet to data sheet by using command button

  1. #1
    Registered User
    Join Date
    09-16-2014
    Location
    Vietnam
    MS-Off Ver
    2007
    Posts
    3

    Question Transfer data from input sheet to data sheet by using command button

    Hi All

    My name is Vinh, from Vietnam, today i just watch a video from Mr Takyar. Here is the link: http://www.youtube.com/watch?v=grrETxZrks4

    His lesson is show how to transfer data from this sheet to another sheet using a command button but when i try, it just can transfer data to another sheet only 2 row

    May be Mr Takyar, he make some mistake, i want a code can transfer data more than 2 row

    Anyone please help me to adjust Mr Takyar's code.

    Thank you
    Last edited by vinh1985; 09-16-2014 at 09:32 PM.

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Problem with VBA code - I am a amatuer - Need help

    Can you please post a sample of your workbook so we don't have to watch the whole video and create the work from scratch?

    Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Problem with VBA code - I am a amatuer - Need help

    Hi, welcome to the forum

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    09-16-2014
    Location
    Vietnam
    MS-Off Ver
    2007
    Posts
    3

    Re: Problem with VBA code - I am a amatuer - Need help

    Dear All
    This is data i make base on lesson
    But it only can transfer data form sheet register to sheet data only 2 row

    Please help me to adjust the code so they can transfer data more than 2 row

    Thank you
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-16-2014
    Location
    Vietnam
    MS-Off Ver
    2007
    Posts
    3

    Re: Problem with VBA code - I am a amatuer - Need help

    Dear All

    i already fingerout problem, it not about the code

    Problem is merge cell in cell title can effect to the result

    Thank all - no need to help me anymore

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Code Problem: How to Write this into a VBA code
    By rlkerr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2013, 02:46 AM
  2. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  3. VBA Code Problem
    By waqarqrl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2012, 01:46 PM
  4. Code problem.
    By Flower R in forum Excel General
    Replies: 0
    Last Post: 12-15-2008, 09:42 PM
  5. Problem with the end of this code
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2005, 08:05 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1