Duplication data every time macro is run, instead of updating newly found data only

Hi,

I had posted my problem before and thought it was solved after receiving great help.

(http://www.excelforum.com/excel-prog...ml#post2266996)

However, I just found out that there is a slight problem with the code I had received (for my purpose). It keeps duplicating the data every time the macro is run, while I need it to just update the new data, found in the worksheet I work on daily, in the specified new worksheet.

Any help on solving this would be very much appreciated. Cheers.

Here's the code and I have also included the sample excel file:

Please Login or Register  to view this content.

Hi Lostinxcel

Try this

Please Login or Register  to view this content.

The code places a marker in Receipts PYMT 2010 when an Item is used so it doesn't get used again.

Hope this helps.

John