Hello,

please tell me how to move the data record in a new sheet and how to delete
the duplicated data record after it was moved to a other steet with a macro:

Karl Maier, Inner Street 2, 43210 Berlin

Unfortunatly my macro at the attached Excel-File does only compare one cell
(in this case firstname).
Please let me know how to modify the macro in my Excel-File that there is a
comparison of street, zip-code and city and not only of the firstname.

Thank you.

Regards,

Dirk

First add a heading in A1:E1 like a,b,c,d,e. Then:

Range("A1").CurrentRegion.AdvancedFilter xlFilterCopy, , Range("G1"), True

--
Jim
"Dirk Lehmann" <dirk_lehmann@arcor.de> wrote in message
news:482ac339$0$6542$9b4e6d93@newsspool3.arcor-online.net...
| Hello,
|
| please tell me how to move the data record in a new sheet and how to
delete
| the duplicated data record after it was moved to a other steet with a
macro:
|
| Karl Maier, Inner Street 2, 43210 Berlin
|
| Unfortunatly my macro at the attached Excel-File does only compare one
cell
| (in this case firstname).
| Please let me know how to modify the macro in my Excel-File that there is
a
| comparison of street, zip-code and city and not only of the firstname.
|
| Thank you.
|
| Regards,
|
| Dirk
|
|
|