Hello to all,
I have been trying to get a macro working for a while. I must thank MD at VBAexpress for all his help in putting together this piece of code. I need to modify it a little bit for it to do what I want it to do. As of now, data is gathered from Sheet1 and Sheet3 and copied to Sheet2. The problem is that it duplicates the values already copied in the first run of the macro. At this point I'd say all the code is missing is a line to check that the data it's copying is not already in the target sheet. I am totally at a loss when it comes to VBA programming which is the reason why I have not been able to do it. see the worksheet attached. I need your help.
.
http://www.thecodecage.com/forumz/mi...plication.html
http://www.vbaexpress.com/forum/show...t=40784&page=2
http://www.mrexcel.com/forum/showthread.php?t=610954