When it finds the corresponding data; the exact same Number as I entered, I want it to show the corresponding costumer information such as name and adress.
This can be done by the last line in the code.

I want it to search in sheet4, as defined in the code.

Thanks for the reply!