Hi!

I am brand new to this and have been hunting all morning for a solution to my problem, and am getting more and more confused. I need to be able to get Excel '07 workbook to do the following:

A) copy and paste from sheet1/column C into Sheet 3/Column A, and sheet 2/column B into sheet 3 / column C
B) then check if it is a duplicate, if so to ignore the other instances
C) trigger a time stamp for sheet 3/ columns B & D.
D) I also need it to NOT allow the user to delete any information from sheet 3.

I have been able to get a simple copy paste to work, but only if it is one column and one cell (ie, sheet 1 / column c into sheet 3 / column A), then trigger a time stamp too. But again that is not working when I try to get it to give me the second stamp for column D.

Help!!