asked on

Delete redundant data records

Dear Experts:

I got an excel file where redundant data records have to be deleted based on certain criteria. I attached a sample file with the exact requirements.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

Delete-Redundant-records.xlsx

ASKER CERTIFIED SOLUTION

ragnarok89

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andreas Hermle

ASKER

Hi ragnarok89:

thank you very much for your swift help.

Since I am a rookie at VBA coding, could you please declare the variables ...
startval and Row

I am receiving error messages in this respect.

Help is much appreicated. Thank you very much in advance.

Regards, Andreas

Andreas Hermle

ASKER

Hi ragnarok89:

I just declared both variables as variants and added 'on error resume next'. Works like a charm. Thank you very much indeed.

GREAT job from your side! I really appreciate it.

There is one thing I would like you to show me. The range should be computed/detected automatically by the macro and not be hard coded. I got thousands data records.
How is this achieved?

Thank you very much in advance for your great help.

Regards, Andreas

SOLUTION

ragnarok89

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Andreas Hermle

ASKER

Hi ragnarok:

great job. Thank you very much for your professional support. Regards, Andreas

ragnarok89

My pleasure.