Address for each instance of duplicated record

[kmakjop]

Hello,

I know the general rule is to start your coding first, then post what you have in order to get hell, but honestly I am having an issue getting this started.

I have a transaction ID that's being tracked in column "T", if it detects a duplicated record it alerts the user via message. My issue is, how do I put in a message box the address for each instance of the duplicated record? I can get the address for the current instance of the duplication, I just cant figure out how to get the address for the previous instance.

[bebo021999]

Could you attach a sample file?

[kmakjop]

I will work on putting a sample file togther, everything is somewhat a mess right now. In the interim, this is code that I am using alert the user of the duplicated record found in column "T". I just need to find out how to find the address of both duplicates.

Please Login or Register  to view this content.

[bebo021999]

I could not find somewhere the code trigger change in column T?

And, does the formula in column H help to find dupplication in column T? What is it?

[jolivanes]

Looking for the first same Value as Range(E1) in Column T.

Please Login or Register  to view this content.

[kmakjop]

Looking for the first same Value as Range(E1) in Column T.

Please Login or Register  to view this content.

@Jolivanes, I am trying to edit your code to make it work, but apparently I dont fully understand the code. I used formulas to identify the duplicates in column "T", it is highlighted immediately while the user is typing and a message shown. I then clear out, cells: "H, I and J" of the same row to force the user to reenter the data. The challenge is, I want to show the address of the duplicates found, first the one in the active row in column "T" then the other one somewhere else in the same column "T". How do i accomplish the last part of displaying the address of duplicates in column "T"?

[kmakjop]

I could not find somewhere the code trigger change in column T?

And, does the formula in column H help to find dupplication in column T? What is it?

@bebo121999 I used formulas to identify the duplicates in column "T", it is highlighted immediately while the user is typing and a message shown. I then clear out, cells: "H, I and J" of the same row to force the user to reenter the data. The challenge is, I want to show the address of the duplicates found, first the one in the active row in column "T" then the other one somewhere else in the same column "T". How do i accomplish the last part of displaying the address of duplicates in column "T"?

[jolivanes]

Read Post #2 again.

[kmakjop]

Kindly see the attached sample workbook, thank you for trying to assist.

Shipping Log sample.xlsm

[kmakjop]

Any suggestions please

[kmakjop]

I am just trying to display the addresses of the duplicates found in column "T". Any suggestions would be greatly appreciated.

[jolivanes]

I don't see any duplicates in Column T that we can use for testing.

Re: "I just cant figure out how to get the address for the previous instance."
Explain what this means please.