+ Reply to Thread
Results 1 to 4 of 4

Macro To copy data and paste in another sheet

  1. #1
    Registered User
    Join Date
    03-24-2016
    Location
    Nicaragua
    MS-Off Ver
    2016
    Posts
    40

    Macro To copy data and paste in another sheet

    Hello Excel Forum,

    I am looking for some help. I have a file that contains data in "Sheet 1". I am looking for a macro that does the following:

    1. Copies the data and paste it in "sheet 2"
    2. Deletes the data that has been copy-pasted in "sheet 2" from "sheet 1", that way the user can start entering data again
    3. Summarize the data in "sheet 2" without deleting any previous data in "sheet 2"

    The purpose of this file is to have the user enter data for one date, the macro will consolidate the data and the user can enter the data for the following date.
    I am attaching a file to better explain what I need to do.

    "Sheet 1" contains the data that will be copy pasted (this data needs to be wiped out or erased once it is copy pasted in the next sheet)
    "Sheet 2" is the desired result
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Macro To copy data and paste in another sheet

    Try this.
    Please Login or Register  to view this content.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  3. #3
    Registered User
    Join Date
    03-24-2016
    Location
    Nicaragua
    MS-Off Ver
    2016
    Posts
    40

    Re: Macro To copy data and paste in another sheet

    Marking the thread as resolved

    Thank you skywriter

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Macro To copy data and paste in another sheet

    My pleasure, thanks for the feedback and rep. points.

+ 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. Macro to copy paste data to other sheet without zero value
    By triaji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2015, 03:07 AM
  2. [SOLVED] Macro to copy data from one sheet, paste in another sheet
    By papi-O in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2014, 04:06 AM
  3. Copy and Paste data from different sheet - No Macro Please
    By abduljaleel.mca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 10:45 AM
  4. Macro to Copy data from one sheet and paste to another sheet based on a condition
    By SaurabhShri1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-20-2013, 09:30 AM
  5. macro to copy and paste data to new sheet
    By mypassion1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-08-2009, 10:02 AM
  6. Macro to search the sheet name and copy and paste the data from a major sheet
    By salma2009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2009, 02:11 AM
  7. Macro to Copy/Paste Data from One Sheet to Another
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-09-2007, 02:36 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1