Copy and paste method to notify when last...

Good day everyone,
Here is my goal. I have a "Report" sheet with multiple duplications in column A (starting at row 5). I need a msgebox to pop up when there is only one left, therefore no more duplications.

The problem is I have the following code when I transfer my information from Sheet to Sheet:

Please Login or Register  to view this content.

I need to also search if this transfer has duplicates, if yes do nothing, if no then let the user know that this is the last "A & Activecell.row".

Up,
Can't find anything.

only one left, therefore no more duplications.

You may try conditional formatting to see how duplicates work. You can use a colour to highlight duplicates. As soon as you delete one duplicate, the colour disappears since that row is not longer a duplicate.

Use countif to determine the number of times something appears?
e.g.

Please Login or Register  to view this content.

Yudlugar
Thank you for the start up code... I will try to make it work on the Activecell.row.

What it is doing right now is poping the message everytime A5:A is selected. (Even if there is duplications)

AB33... I thought about doing that but it will be to much for the end Users... They will get confused. I am trying to make it VB as they wont need to do anything to my workbook Only to get messages and populate certain fields.

Thank you guys I will try to work on this code...

Modification:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

?

Tinbendr,
The user will wait until the delivery has been complete then will double click the Activecell.row of the one that needs to be sent to archives, therefore the one that is finished. Then I want it to look if there is anymore project number of the same, if yes then do nothing but if it is the last one to have a msgbox appear to let them know to close the "physical" file.

I cannot post my actual workbook as it is 300kb and cannot chop it off as there is to many codes. I will try to delete some stuff to make it a little bit more understandable.

This code needs to be inserted in the first code posted as this will let the user know when there is no more "duplicate" file number of the same.

I will try to post a workbook

Here is an example of my two last worksheets.

When you double click on Column A (The active Cell Row) it will show you a UserForm with 2 options...

In column A there is the File Number and in Column N will be the Contract number. All contracts is part of the same File number. This is only for one example.

I added 12 contracts. Therefore 12 File number will be the same... When you double click on Column A vs the file/contract number you want to sent to the archives sheet select "Complete" it will transfer the information to the Archive sheet... When you return and to them all they will eventually all be transfered. I need it when the user has reached the last one...to generate a msgbox saying "Last Contract" or range("A" & Activecell.row)...blah blah...


Test.xlsm

Yeah just realized that I was putting the code in the wrong place... Thank you guys it works perfect and that is what I was looking for :D

Thank you