I'm not sure it's a better idea, but I like to put the key (name/id/something)
on every row. It makes it easier to use data|filter|autofilter, subtotals,
pivottables...

David wrote:

David wrote

I'm not married to the idea of a listbox on a userform if other
suggestions would accomplish the same thing.

For now, here's what I did:

Ran Advanced Filter to find unique records in ColA, selected names and
copied to a helper column, set up an autoshape that when clicked ran this
macro after selecting target name in that helper column:

Sub FindName()
Columns("A:A").Find(ActiveCell.Text).Activate
End Sub

If anyone has a better idea, please chime in.

--
David

--

Dave Peterson