Does ayone know how I can create a search function which seaches a worksheet with load of different entries (1 entry per row) then returns possible search results in a userform (i.e if you search by owner the owner may own more than one account so you would need to retur all possible results)

I then need the user to select which is the right one and then be able to edit it if possible. I guess this would involve telling the macro which row the entry is on to be able to retrieve all the data already inputted. At present each row has a unique reference number.

If you can help me with this you are a genius! Thanks