Results 1 to 4 of 4

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

Threaded View

  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.

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