Did i enter this before?

[hansjeu]

Hello.
I am programming a excel sheet at the moment and have a problem.
The sheet has more as 2000 rows, names, addresses etc.
voorbeeld.jpg
Now my problem.
Sometimes i have to enter the data of a person i know i have enters before.
Sometimes i know the firstname, sometimes i know the lastname, sometimes i know even the street etc etc.
I fill this data in. now i am looking for a macro that gives me the number of te row(s) where i can find the matching data.
I can't get it to work.
Can someone help.

Thanks Hans

[Bernie Deitrick]

1) Copy this code.
2) Right-Click the sheet tab of interest.
3) Select "View Code"
4) Paste the code into the window that appears.
5) Save the file as a macro-enabled .xlsm file.
6) Choose which message box you prefer

Please Login or Register  to view this content.

[hansjeu]

Thank you very much Bernie.
But this is not exactly what i am searching.
I would like to compare all my data (which I have entered) against all rows.
But thank you again.

Greetings Hans

[Bernie Deitrick]

You could run this, either manually or based on an entry in a specific column:

Please Login or Register  to view this content.