Finding a matching cell

[gbWildy]

Unique customer numbers is stored in Sheet 2 in column A

I want to enter a customer number in Sheet 1 cell A1 and I want a macro to search and select the cell that matches it in Sheet 2

What code do I need in the macro for this to work?

[antoka05]

See the attached file... I hope it's what you need.

Regards,
Antonio

[gbWildy]

yes it works perfectly

Thanks