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

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

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

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Andreas Hermle

ASKER

Hi ragnarok:

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

ragnarok89

My pleasure.