Duplicates
Is there a way to be flagged when adding a duplicate record. My spreadsheet
is set up with records in rows...I want to know when I am entering a duplicate invoice number, which is a value stored in a single column of the row. I want to be allowed to enter duplicates, I just need to know that it IS a duplicate. Any suggestions? -- KKD |
Duplicates
Got it, thanks!
-- KKD "KKD" wrote: Is there a way to be flagged when adding a duplicate record. My spreadsheet is set up with records in rows...I want to know when I am entering a duplicate invoice number, which is a value stored in a single column of the row. I want to be allowed to enter duplicates, I just need to know that it IS a duplicate. Any suggestions? -- KKD |
Duplicates
One way. Right click sheet tabinsert thischange column 1 to suit yours
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column < 1 Then Exit Sub lr = Cells(Rows.Count, 1).End(xlUp).Row If Application.CountIf(Range(Cells(1, 1), _ Cells(lr, 1)), Target) 1 Then MsgBox "Dup" End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "KKD" wrote in message ... Is there a way to be flagged when adding a duplicate record. My spreadsheet is set up with records in rows...I want to know when I am entering a duplicate invoice number, which is a value stored in a single column of the row. I want to be allowed to enter duplicates, I just need to know that it IS a duplicate. Any suggestions? -- KKD |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com