Deleting identical rows between different sheets? 1

[wakingedge42]

Hi all, I'm trying to create a VBA Excel macro that automatically deletes any rows in Worksheet1 that are also on Worksheet2. Individual cells that match on both sheets don't matter, all that matters is if entire rows match between sheets. Can anyone help?

 

[SkipVought]

Hi,

Why do you have the same data on different sheets?

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}

 

[TonyJollans]

Have a look at Dave Brett's Duplicate Master. I think it will do what you want.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association

 

[wakingedge42]

Well actually, I need this for my work computer and I don't have access to install software, so I need it to be an Excel macro.

Basically, every day I receive certain reports, which are in Excel format. Each day's report contains old and new entries, but I'm only concerned with the new ones, so that's why I need to delete identical rows between sheets.

Thanks for the responses though. Anyone else?

 

[SkipVought]

A simple query would do that, returning DISTINCT rows. faq68-5829

Skip,

_{To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white]}