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.
Bookmarks