Hi my first post and thank you for welcoming me onto your site ok here goes...
I have a cell H10 for instance where i enter the surname of my client
i would like a macro to get the info fron this cell and search down colum b10 onwards locate the surname and display the full line the selected surname is on, pretty basic for someone but its stumped me for weeks..

Hope you can help Speak soon Steve