Match LastRow to Rows Above to Check for Duplicates Rows

**Hudas** · 03-12-2012, 10:42 AM

Hi -

I have a macro that adds a data after the last used row of the sheet coming from another sheet. What I want is macro that will check if the last row that I added is already present on the sheet. Data Column "A" is there identifier, so the comparison will start from column B until to the last used column for that row. I've attached a sample sheet. When there is duplicate I want a message box to pop up.

Hudas

**Kelshaer** · 03-12-2012, 10:56 AM

Here You Go:

Please Login or Register  to view this content.

**Hudas** · 03-12-2012, 11:32 AM

Hi Kelshaer,

Thank you very much for your time, If I understand your code correctly it checks column B to H right? My original data goes until column AK, if its not too much to asked can you please edit your code to check until column AK and instead of the pop up base on the row would be fine if the reference will be the value in column A?

Please thank you very much..
Hudas

**Kelshaer** · 03-12-2012, 11:39 AM

Here you Go:

Please Login or Register  to view this content.

**Hudas** · 03-12-2012, 11:57 AM

Hi Kelshaer-

Thank you very much for your help.. I really really appreciate it!! Have a good day sir!

Hudas

**Hudas** · 03-13-2012, 06:03 AM

Hi -

Just a follow-up question.... Would it be possible to display on the message box both reference on column A for the duplicates?, not just the duplicate found but also the row it was compared from.

Hudas

**Kelshaer** · 03-13-2012, 07:37 AM

No Problem

Please Login or Register  to view this content.

**Hudas** · 03-13-2012, 08:10 AM

Hi Kelshaer,

Again thank you for you time and Thanks a lot for your help.

Hudas

Match LastRow to Rows Above to Check for Duplicates Rows

LinkBack

Thread Tools

Rate This Thread

Display

Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Re: Match LastRow to Rows Above to Check for Duplicates Rows

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions