Copy paste or replace

Hello,

I need to copy data from worksheet1 to worksheet2. I have managed to do so by using a Macro (see below) that copies the defined cells from the worksheet1 onto the worksheet2. It also creates to each entry (row) an ID and the entry date (based on the formula =NOW()).

I am able to edit the data from the worksheet1 using the Vlookup fomula based on the worksheet2 combine with copy/paste values.

Once I modify the entry on worksheet1, I need to save it back but the current Macro would just create me a new entry/ID on the worksheet2.. Would you know how to replace the existing row (finding the current ID present on cell D8 on the worksheet1 and to remove the duplicate on the worksheet2)? If ID not present on cell D8 it should just run my macro I guess.

Here is the Macro I am using to copy de data from worksheet1 to worksheet2

Please Login or Register  to view this content.

Many thanks in advance,
Graig

Your code tags had to be input in the 1st post, i have deleted your duplicate post and put code tags for you in the first post.