+ Reply to Thread
Results 1 to 4 of 4

how to copy only new row(s) from one sheet to bottom of others based on criteria

  1. #1
    Registered User
    Join Date
    12-13-2013
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2013
    Posts
    6

    Cool how to copy only new row(s) from one sheet to bottom of others based on criteria

    Good Morning,

    I've combed through your Forum most of yesterday and can't figure out how to do this - sorry. The attached spreadsheet is a simple sample of how the actual workbook is set up. There will be an endless amount of rows as time goes on. I found some code which I have no idea how to write, but I tried my hand at adding some data to match this sheet. What we are trying to do is that each time new information is added, we would like it to copy that entire row and add it to the bottom of the sheet that matches the criteria. In this case, it is the Store name. When I use the code I found, it does copy initially. Then when I add a new row and run the Macro, it adds all the rows instead of just the new ones. I highlighted what is happening on the Shop sheet tab. Is there a way for the code to be modified to add only all new rows to the individual sheet(s) for each Store? I hope this makes sense. This is only my 2nd post in 6 years, and you all were so helpful. Thanks for any advice on this project.
    Attached Files Attached Files
    Last edited by davesexcel; 09-27-2019 at 12:37 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,504

    Re: how to copy only new row(s) from one sheet to bototm of others based on criteria

    Hello,
    What determines a new item?

  3. #3
    Registered User
    Join Date
    12-13-2013
    Location
    Bloomington, Indiana
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: how to copy only new row(s) from one sheet to bottom of others based on criteria

    Good Afternoon,
    I'm sorry to just get back to this question. Our project person was out at a conference, and has returned. They did not think about how to determine a new item. If we incorporated a field to include a checkbox, would that work in a formula if it was only checked when new, then once copied to another sheet they could uncheck manually?

  4. #4
    Valued Forum Contributor
    Join Date
    06-29-2014
    Location
    Australia
    MS-Off Ver
    MSO 365
    Posts
    810

    Re: how to copy only new row(s) from one sheet to bottom of others based on criteria

    Hello Rita,

    Dave might have something else in mind but here's a starting point:-

    Please Login or Register  to view this content.
    I've attached your sample workbook with the code implemented and assigned to Scooby's image.. Click on Scooby's image to run the code.

    BTW, you added your code to the ThisWorkbook module. I have removed it in the attached sample as it is not an event code and needed to be placed in a standard module. Check the Project Explorer to see what I mean.

    I hope that this helps.

    Cheerio,
    vcoolio.
    Attached Files Attached Files

+ 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. Replies: 19
    Last Post: 10-16-2017, 12:34 PM
  2. Automatically copy rows to another sheet based on criteria, when original sheet is updated
    By NoviceProgrammer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2016, 02:14 AM
  3. Replies: 2
    Last Post: 01-23-2016, 01:16 PM
  4. [SOLVED] Consolidated Summary Sheet - Copy data from one sheet to other based on criteria
    By sabha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2015, 03:29 AM
  5. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  6. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  7. Need Macro to search from mater sheet and copy in another sheet based on Criteria
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-29-2012, 01:03 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