VBA to copy only new data from One sheetsheet to another

[Chasedward]

Hi, I have a excel workbook, where the front sheet has every entry of all the worksheets where everyone enters their snagging lists to, and then each worksheet belongs to a project. At the moment we are manually entering to the first sheet and then copying to the relevant project. What I am trying to find is a VBA script which will copy the entries when added to the front sheet to the relevant worksheet for the project. Each Worksheet is named after the project. Column A of the first sheet is named after the project. All columns have to be copied over as they are entered on the front sheet. My problem is I can only find a vba script which will copy everything over which is overwriting what is already on the Project Worksheet, which has had dates etc., added to it and this is wiping out the dates. I need it to see if anything new has been added and only copy over those new values and nothing which is already there. Is this possible?

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not a pictures) of your front sheet and at least one of the project sheets . Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).