Closed Thread
Results 1 to 4 of 4

Need help with sending data from one sheet to another with a click of a button.

  1. #1
    Registered User
    Join Date
    05-20-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Need help with sending data from one sheet to another with a click of a button.

    I have attached a a spreadsheet to this thread for reference.

    I need to get the data from the sheet 1 added to the sheet 2 by clicking on the ADD DATA button in the sheet 1.
    The sheet 1 will be filled in multiple times like a form by the users, so once the data is added to the sheet 2 I would like sheet 1 to have no data filled in the column to the right.
    The data will be only filled in the right column, thus the left column should not be copied to the sheet 2.

    Please hep me with a way to solve this problem.

    Thanks in anticipation!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Need help with sending data from one sheet to another with a click of a button.

    here you go, the macro copies the input to the appropriate cells and then clears the data to be filled in again

    Execl_help.xlsb

  3. #3
    Registered User
    Join Date
    05-20-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Need help with sending data from one sheet to another with a click of a button.

    Thanks Scott! But have an issue, the code that you have written does everything I want, but I also want the data to be retained as a next line of data is entered.
    Once we fill in data in the sheet 1 and click add data it sends data to the 1st row in the next sheet and if another set of data is entered in the sheet 1 and added then it erases the previous row. What I wanted to do is as when data is entered the data should be added in the rows below,hence retaining the data in the sheet 2.

    Please look into this as well.

    Thanks again!

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help with sending data from one sheet to another with a click of a button.

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

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